Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Brooklyn, ny

    Unanswered: join expression in where clause

    I have three tables in access that I have to join by SildTo column.
    The first table cast, contains all soldto data, and other might or might not.
    I need to create a query to show all information from cast and the other two tables even if the soldto not in some tables.

    where cast.soldto(+) = table1.soldto
    and cast.soldto(+) = table2.soldto

    How to do that in access?

    Thank you.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Use left joins in your FROM clause instead of trying to do it in your where clause. You COULD do it in the where clause by allowing nulls as well.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    Popping it into the FROM clause as an outer join is, however, ANSII compliant and thus can be used in just about RDBMS as opposed to translating propietary SQL as you are having to do now.
    pootle flump
    ur codings are working excelent.

Posting Permissions

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