At 4/10/2003 05:29 PM, Thomas SteinMaurer wrote:

> > select
> > p1.name, p2.name
> > from
> > products p1
> > left join products p2 on (p2.name = p1.name)
> > where
> > p1.account_id = 1 and
> > p2.account_id = 2
> >
> >
> > Is this not possible? I know that if there was a Product1 and a Product2
> > table, the left join would work correctly.
> >
> > Using FB1 on W2k.
>
>Does a LEFT OUTER JOIN help?
>
>Or did I miss something?

Left Join = Left Outer Join, so no help there.


thanks anyway,

Bob M..