>SELECT DISTINCT Table1.Part_number, Table2.St, Table2.State_name ; > FROM Table1 LEFT JOIN Table2 ON Table1.Part_number = Table2.Part_number ; > INTO CURSOR MyResult ----------------- This almost works....table2.part_number needs to be DISTINCT..:)
Robert Keith Independent Developer San Antonio, Texas E-mail address: rebelrob1@yahoo.com