Results 1 to 2 of 2
  1. #1

    Joins in Queries

    I am curious about inner and outer joins used in queries, why and when would you use them. I understand relationships and referential integrity, but why you need to use inner and outer joins in queries puzzle me.


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts

    Re: Joins in Queries

    Let's assume that tables A and B are linking one-to-many by and ID field. The INNER JOIN is easiest to understand: basically it outputs a record for each pair of records that having matching fields. So, for each record in table A, you get 1 record in the query for each of the matching records in table B. (but no record from table A if there are no matching records in [img]/forums/images/smilies/cool.gif[/img].

    The OUTER JOIN provides at least 1 record in the query from table A EVEN IF there are no matching records in table B.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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