Pages

▼

Saturday, January 31, 2009

What is a join and explain different types of joins

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.
at

2 comments:

  1. kalitJuly 17, 2009 at 2:13 AM

    Please also brief about differnt types of joins

    ReplyDelete
  2. Vijaya KadiyalaJuly 17, 2009 at 7:32 AM

    Hi Kalit,
    Yes, I am going to do that in my next article.

    ReplyDelete