请问:如何将表a和表b,join成为表 c ?
=======================================================table a: name date val1
aaa 2004-4-2 20
bbb 2004-4-3 30
table b: name date val2
aaa 2004-4-1 20
aaa 2004-4-2 10
bbb 2004-4-3 40table c: name date val1 val2
aaa 2004-4-1 NULL 20
aaa 2004-4-2 20 10
bbb 2004-4-3 30 40
=======================================================table a: name date val1
aaa 2004-4-2 20
bbb 2004-4-3 30
table b: name date val2
aaa 2004-4-1 20
aaa 2004-4-2 10
bbb 2004-4-3 40table c: name date val1 val2
aaa 2004-4-1 NULL 20
aaa 2004-4-2 20 10
bbb 2004-4-3 30 40
SELECT INTO 语句创建一个新表,并用 SELECT 的结果集填充该表。新表的结构由选择列表中表达式的特性定义,例如:SELECT Shippers.*, Link.Address, Link.City,
Link.Region, Link.PostalCode
INTO NewShippers
FROM Shippers
JOIN LinkServer.DB.dbo.Shippers AS Link
ON (Shippers.ShipperID = Link.ShipperID)SELECT INTO 可将几个表或视图中的数据组合成一个表。也可用于创建一个包含选自链接服务器的数据的新表。看看sql server的帮助