IS left join the right way?
I have two tables.
Table1 has around 20000 rows. Table2 has 2500 rows.
fields in Table1:
fields in table2
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!
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
By franklch in forum Database
Last Post: 05-19-2005, 05:39 PM
By maxpenguin in forum Database
Last Post: 04-13-2005, 07:01 AM
Last Post: 09-24-2002, 01:31 AM
Last Post: 03-18-2002, 11:25 AM
By John Pierson in forum Database
Last Post: 01-18-2001, 02:10 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center