SELECT Table1.Part_number, Table2.St, Table2.State_name ; FROM Table1 LEFT JOIN Table2 ON Table1.Part_number = Table2.Part_number ; INTO CURSOR MyResultI have no idea why you said you cannot use a left join as that is what will give the result you are asking for.