Posted by Robert Klemme on 03/21/06 11:10

John Bokma wrote:
> "Stu" <stuart.ainsworth@gmail.com> wrote:
>
>> It would help if you posted DDL and some sample data, but it sounds
>> like you simply need to do a dual join on your second table using an
>> alias, eg:
>>
>> SELECT a.*, b1.*, b2.*
>> FROM tableA a JOIN TableB b1 ON a.ID = b1.ID
>> JOIN TableB b2 ON aID2 = b2.ID
>
> which gives me way too many rows :-) (or I did something very stupid)

Maybe you joined the second table only once with a criterion on both id
rows and thus got far less results. But that would be wrong if your
description of the problem was right.

Regards

robert

[Back to original message]