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
Examples:
INNER JOIN
OUTER JOIN
RIGHT OUTER JOIN
LEFT OUTER JOIN
FULL JOIN
SELF JOIN
CROSS JOIN
No comments:
Post a Comment