What is a join and their types?

Answers were Sorted based on User's Feedback



What is a join and their types?..

Answer / s.chithiravelu

Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.

Various Types of Joins:

Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins

Is This Answer Correct ?    4 Yes 0 No

What is a join and their types?..

Answer / hari

Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  


What is tcl in sql server?

0 Answers  


explain declarative management framework (dmf) in sql server 2008?

0 Answers  


Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  


What are the aggregate and scalar functions?

0 Answers  






What is a group function explain with an example?

0 Answers  


What is data source document?

0 Answers  


Explain how many normalization forms?

0 Answers  


What is nested transaction?

0 Answers  


What does ss stand for sexually?

0 Answers  


Why should we go for stored procedures? Why not direct queries?

0 Answers  


How to turn off warning messages during php execution?

0 Answers  


Categories