IS left join the right way?

[whygh]

Hello everyone,

I have two tables.
Table1 has around 20000 rows. Table2 has 2500 rows.

fields in Table1:
sdq03
lin03
....

fields in table2
sb_code
ship_id
.....

I want to create a new table(lin03,shipid) based on the two table join together.
shipId in new table is if sdq3=sb_code and ship_id<>"" then shipId=table2.ship_id. else shipid=sdq03.

can I implement it with "select...into ". how to write SQl statement.

thanks in advance!

[Phil Weber]

What kind of database?

[whygh]

FoxPro

thanks