Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

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


No comments:
Write comments

Infolinks

Services

© 2014