I guess you also needed the "st" field. Just add that to your field list (after "SELECT").

select table1.part_number, table2.st, table2.state_name ;
from table1, table2 ;
where table2.part_number = table1.part_number ;
into yada yada

Regards,

Mike