Results 1 to 3 of 3

Thread: Outer Join

  1. #1
    Join Date
    May 2004
    Location
    NH
    Posts
    87

    Unanswered: Outer Join

    quick question:

    I searched around and there doesn't seem to be any other way to express an outer join unless you specify it in the FROM clause? i.e. in oracle it's
    Code:
    SELECT * FROM tab1, tab2 WHERE tab1.id = tab2.id (+)
    In access it's:
    Code:
    SELECT * FROM tabl1 RIGHT JOIN tab2 ON tab1.id = tab2.id
    Is there any other way in access? I already have a complex query written without expressing INNER JOIN, RIGHT JOIN, etc in the from clause, but rather in the traditional WHERE key1 = key2.

    Thanks,
    Warren
    -Warren
    Hack the Planet.

  2. #2
    Join Date
    May 2004
    Location
    NH
    Posts
    87
    I figured out a way around it:
    Code:
    SELECT * FROM newData RIGHT JOIN q1 ON newData.ids = q1.ids
    Where q1 was the complex query I initially spoke of (SELECT ... )

    I'm still curious to see if there is another way to express an outer join... please respond even if it's no.
    -Warren
    Hack the Planet.

  3. #3
    Join Date
    Sep 2004
    Location
    Kuala Lumpur
    Posts
    60
    from what i've found so far, what you've done isn't "a way around it", it's *it*.

Posting Permissions

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