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
[Back to original message]
Copyright © 2005-2006 Powered by Custom PHP Programming