Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    31

    Unanswered: Joins? How do you know which to use?

    Hello everyone,

    I have a basic question about the difference between the inner, outer, left, right and then the various combinations of them. What do they mean and how do you know which one you need?

    Any insight would be appreciated.

    Frank

  2. #2
    Join Date
    Feb 2004
    Location
    Washington
    Posts
    49
    An inner joins returns only those records where a record exists in both tables.

    A left outer join returns all of the records from the left table even if there is no corresponding record in the table on the right.

    A right out join returns all of the records from the right table even is there is no corresponding record in the table on the left.
    Cathy

  3. #3
    Join Date
    Jan 2004
    Posts
    31
    thank you, that simplifies things a bit.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •