Tuesday, 15 March 2011

SQL JOINS


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


Friendly Learn Translate to Tamil

Smilely

Services

© 2014