Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    17

    Question Unanswered: Outer Join in Access

    Hello
    I want to write a query that does an outer join (i.e. All the records from tbl1 and the related records if any from tbl2).

    SELECT filed1, filed2..
    FROM request_tbl OUTER JOIN Application_tbl ON Application_tbl.Application_Id = request_tbl.App_Id;


    this fails saying syntax error.
    is there a way in which i can create an outer join in Access 2000?
    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Outer Join in Access

    Try this:

    SELECT filed1, filed2..
    FROM request_tbl LEFT OUTER JOIN Application_tbl ON Application_tbl.Application_Id = request_tbl.App_Id;


    The normal way, however, isn't to write SQL, but to use the design mode, and to double click on the relation. here, you can specify OUTER joins.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Oct 2002
    Posts
    17

    Re: Outer Join in Access

    thanks. that worked great!


    Originally posted by DoktorBlue
    Try this:

    SELECT filed1, filed2..
    FROM request_tbl LEFT OUTER JOIN Application_tbl ON Application_tbl.Application_Id = request_tbl.App_Id;


    The normal way, however, isn't to write SQL, but to use the design mode, and to double click on the relation. here, you can specify OUTER joins.

Posting Permissions

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