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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL