100分求sql语句.(100分)

7

701004158

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-18

• #1

表A(aa,bb,cc,dd,ee)
表B(a1,b1)
怎样将表B的内容插入到表A?
其中aa=a1(aa为主键)
bb=b1
cc不为空,可以是定值x
dd=a1
ee=a2
即插入后表A的某一行是(a1,b1,'x',a1,b1)
谢谢了.

 

L

lgzh_3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-18

• #2

insert into A select a1,b1,'x',a1,b1 from b

 

L

lgzh_3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-18

• #3

insert into A select *,'x'* from b
SQL SEVER2000测试通过

 

D

dey-999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-18

• #4

insert into A select a1 as aa,b1 as bb,'x' as cc,a1 as dd,b1 as ee from b where a1 not in(select aa from A)

 

网

网中戏

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-18

• #5

顶