>My guess is that you tables are like this
>table1
>state_id c(2)
>
>table2
>state_id c(2)
>state_name c(25)
>
>select *;
>from table1, table2 ;
>where table1.state_id = table2.state_id ;
>into yada yada
>
>>In table1, I have a field called STATE that is 2 char long. I have another
>>that has the two char STATE field and a 25 char state full name field….for example…
>>
>>Table called – table2
>>Fld1 Fld2
>>TX TEXAS
>>NY NEW YORK
>>Etc….
>>
>>I want to use a SELECT statement to link up the table1 with table2 so I can have access to the state full name field. I can not use a LEFT JOIN…Is there another way?
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....