Posted by markc600 on 03/21/06 15:57

select coalesce(a.ID1,b.ID1),
coalesce(a.ID2,b.ID2),
a.Qty,
b.Qty
from TableA a
full outer join TableB b on a.ID1=b.ID1 or a.ID2=b.ID2

• Next in forum: Re: charindex question
• Prev in forum: charindex question
• Thread view: Re: Joing tables using more than one field

[Reply to this message]