Joins are used in queries to explain how different tables are related.
Joins also let you select data from a table depending upon data from another table.
Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs.
OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.
Saturday, January 31, 2009
What is a join and explain different types of joins
Subscribe to:
Post Comments (Atom)
2 comments:
Please also brief about differnt types of joins
Hi Kalit,
Yes, I am going to do that in my next article.
Post a Comment