SELECT Table1.Part_number, Table2.St, Table2.State_name ; FROM Table1 LEFT JOIN Table2 ON Table1.Part_number = Table2.Part_number ; <strong>GROUP BY 1</strong> ; INTO CURSOR MyResult