>Hi Stephen....My tables look like this...
>table1
>part_number c(5)
>
>table2
>part_number c(5)
>st c(2)
>state_name c(25)

Robert,

The help file will explain how to combine data from two files with SELECT. Your code would be;

SELECT Table1.Part_number, Table2.St, Table2.State_name ;
  FROM Table1 LEFT JOIN Table2 ON Table1.Part_number = Table2.Part_number ;
 INTO CURSOR MyResult

I have no idea why you said you cannot use a left join as that is what will give the result you are asking for.