At 4/10/2003 05:49 PM, Arno Brinkman wrote:

>select
> p1.name, p2.name
>from
> products p1
> left join products p2 on (p2.name = p1.name and p2.account_id = 2)
>where
> p1.account_id = 1

Brilliant. That did the trick.

Now the question is why?

Bob M..