SQL JOINS

Joins are mostly used when we need to  retrieve data from two or more tables having same fields.It can be used to retrieve data from a single table as well. This blog gives you idea on all kinds of joins with simple examples.

Examples:
INNER JOIN
OUTER JOIN
RIGHT OUTER JOIN
LEFT OUTER JOIN
FULL JOIN
SELF JOIN
CROSS JOIN