explain different types of jions with examples briefly?

Answer Posted / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain having clause?

727


What is mapping schema?

765


Explain microsoft sql server functions?

765


What is RMS migrations?

1884


How do you Implement SSIS Packages in your Project?

1671






What are the five major components of a dbms?

668


What is auditing in sql server?

685


What are the components of sql server service broker?

683


How can sql server instances be hidden?

690


Can you type more than one query in the query editor screen at the same time?

772


Why variables called the most powerful component of ssis?

799


What is self contained multi valued query?

741


List the different normalization forms?

711


Which are new data types introduced in sql server 2008?

808


Define inner join in sql server joins?

715