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
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
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
> >
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
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