Re: Trouble Forming Complex Multitable Query

Do this on your outer join

Datacode(+) = ?

hth
Chris

wendellnsherri_at_hotmail.com (Wendell B) wrote in message news:<c2b207fd.0201211922.7816a98e_at_posting.google.com>...
> ....Record Table Datacode Table
> --------------- -----------------
> | RecordNum |----->| RecordNum |
> | RecordInfo1 | | Datacode |
> | RecordInfo2 | | DatacodeInfo1 |
> | | | DatacodeInfo2 |
> --------------- -----------------
>
> I am trying to perform a query that lists all RecordNum's from the
> RecordNum table and DatacodeInfo from the Datacode table for a
> specific datacode. There are RecordNum's without matching
> DatacodeInfo. I have tried an outer join, but as soon as I specify a
> criteria from the datacode table (like Datacode = ?), the join seems
> to revert back to a simple join.
>
> Can I get the outer join effect of listing all RecordNum's while
> somehow specifying a criteria from the 2nd table? Is there another
> way to do this?
Received on Tue Jan 22 2002 - 22:15:53 CET