>>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.
Jim,
Also, please keep in mind that I inherent these problems, I do not
create them....:).