>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..:)