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