Re: Trouble Forming Complex Multitable Query

Chris,

Thank you so much for your help! Those three little characters (+) are exactly what I needed! The query works great now!

Wendell

christianboivin1_at_hotmail.com (Chris) wrote in message news:<da20daf0.0201221315.1e3f97fd_at_posting.google.com>...
> 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 Wed Jan 23 2002 - 15:50:10 CET