FlipKart Offer

Translate to Tamil

Amazon Best Offer

AliExpress Offers

Online Income

Wednesday, 5 January 2011

What is Different Types of Join ?


JOIN              : Return rows when there is at least one match in both tables


LEFT JOIN   : Return all rows from the left table, even if there are no matches in the right table

RIGHT JOIN : Return all rows from the right table, even if there are no matches in the left table

FULL JOIN    : Return rows when there is a match in one of the tables

 Share This Post


Smilely

Services

© 2014