Re: "left join" record in one joined table and not in another

2006-01-12 Thread SGreen
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/12/2006 12:47:31 AM: > On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > > Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38 > > PM: > > > > > I have three tables joined on key fields: delivery is joined

Re: "left join" record in one joined table and not in another

2006-01-12 Thread Pooly
Hi, 2006/1/12, Vincente Aggrippino <[EMAIL PROTECTED]>: > On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > That fixed it... Thank you! But I don't understand how. Isn't my implicit > inner join the same as the explicit one you used? > > I read Join Syntax in the ref. manual. Is it

Re: "left join" record in one joined table and not in another

2006-01-11 Thread Vincente Aggrippino
On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38 > PM: > > > I have three tables joined on key fields: delivery is joined with > > invoice_detail on delivery_id and with location on loc_id. I want to > return > >

Re: "left join" record in one joined table and not in another

2006-01-11 Thread SGreen
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38 PM: > I have three tables joined on key fields: delivery is joined with > invoice_detail on delivery_id and with location on loc_id. I want to return > records of deliveries that have corresponding records in the location tab

"left join" record in one joined table and not in another

2006-01-11 Thread Vincente Aggrippino
I have three tables joined on key fields: delivery is joined with invoice_detail on delivery_id and with location on loc_id. I want to return records of deliveries that have corresponding records in the location table, but have no corresponding records in the invoice table. Here's the query I'm a