What are joins and mention different types of joins?

Answer Posted / uma sravanthi

JOIN clause is used to combine rows from two or more tables, based on a related column between them.
The types are:
1. Inner Join
2.Outer Join
3.Left Join
4.Right Join
5.Full Join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to test the stored procedures?

197


What do you mean by dml?

176


What do you mean by white box testing and black box testing?

182


What is cmmi and describe different levels of cmm?

203


What is the difference between gui testing and database testing?

197






How to test database manually?

206


How to use sql queries in winrunner/qtp?

186


What we normally check for the database testing?

174


Which sql statements can be used in database testing?

154


What is load testing and give some examples of it?

311


Why database testing is important?

165


How to verify the trigger is fired or not and can you invoke trigger on demand?

217


Explain what is data driven test?

186


What are indexes and mention different types of indexes?

187


What is performance testing and the bottlenecks of it?

164