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

What is data driven test?

192


What are the necessary things needed for writing database test cases?

163


How to test database in manually?

191


How to use sql queries in winrunner/qtp?

193


What is the meaning of record in a database?

184






How does qtp evaluate test results?

198


In data base testing, what are the steps to test data loading?

187


How you can write testcases from requirements and do the requirements represents exact functionality of aut (application under test)?

187


You don’t have much time or only one day time, you have to execute 100 test cases, how you will execute

440


What are dcl commands? What are the two types of commands used by dcl?

207


Define join and name different type of joins?

250


What do you mean by index and explain different types of indexes?

213


How to test procedures and triggers of a database?

206


How to test data loading in data base testing?

210


Mention different types of indexes?

230