Posted by Stu on 03/21/06 00:17

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

HTH,
Stu

• Next in forum: Re: waittype=WRITELOG
• Prev in forum: Reporting a table with two columns from another table
• Thread view: Re: Reporting a table with two columns from another table

[Reply to this message]