>>You just need to join two tables, e.g.
>>
>>select T1.CustNo, T2.QS as 2011_QS, T1.QS as 2010_QS
>>FROM Table1 T1 inner join Table2 T2 on T1.CustNo = T2.CustNo
>
>as this would eat up 8 and 12, my first gut twitch would be to get distinct cust#
>first and left join twice.
See my other reply. If we have Customers which are not in both tables, we need to use FULL JOIN between two tables.
If it's not broken, fix it until it is.
My Blog