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


Do you actully want to search table2 for the part number, then replace the state in table1 with the matching state from table2 ? or just for browsing reasons?

if thats the case then we need to do something all together diffrent

>Hi Stephen....My tables look like this...
>table1
>part_number c(5)
>
>table2
>part_number c(5)
>st c(2)
>state_name c(25)
>I need to match the part_number of both tables and add to table1 the st fld
>and state_name fld...here is some code...
>SELECT table1.part_num,SPACE(2) AS st, SPACE(25) AS state_name FROM table2...what next? maybe I should use SET RELATION....