T1.Custno T1.QS 001 $150.00 004 $650.00 008 $50.00 012 $70.00 060 $95.00 T1.Custno T1.QS 001 $350.00 002 $550.00 008 $750.00 035 $10.00 060 $595.00I want to create a comparison table that includes all the records of both tables, but I want to match up the customers when they are the same.
Custno 2011_QS 2010_QS 001 $350.00 $150.00 002 $550.00 $0.00 004 $0.00 $650.00 008 $750.00 $50.00 012 $0.00 $70.00 035 $10.00 $0.00 060 $595.00 $95.00Thanks....