Trending SQLyog Discussions

What are the Different types of joins and what is different between of each joins? ‎

 

Answer added by  Mohamed Salah
6 years ago

LEFT JOIN ,  RIGHT JOIN .FULL Outer JOIN  

 

Answer added by  Muralee Krishnan K, Project Associate, Indian Institute of Technology and Management Kerala
7 years ago

Different Joins are 1.Left Join  Returns all rows form the left table, even if there are no matches in the right table. 2.Inner Join   Inner join returns records at the i ... See More

 

Answer added by  Deleted user
8 years ago

SQL Join Types: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right ... See More

 

Answer added by  Mohammad Mansuri, Sr. Software Engineer, Newgen Software Technologies Ltd.
8 years ago

there are three types of joints 1) Inner join 2)Left outer join 3)Right outer join