求一数据库adoquery的问题？(15)

A

aynes

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-23

• #1

有表A 表Bno name name tk1 x1 x1 1111112 x2 x2 2222223 x1 x3 3333334 x3目标是生成下面的表no name tk1 x1 1111112 x2 2222223 x1 1111114 x3 333333

 

A

aynes

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-23

• #2

请问一下，这种情况在MS SQL 语句应该怎么写？

 

H

haynes

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-23

• #3

select a.no,a.name,b.tk from a,b where a.name=b.name

 

F

fjw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-23

• #4

select a.no, a.name, b.tk from a left join b on a.name=b.name

 

L

lht123

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-24

• #5

fjw 回答正确

 

G

GodIsWrong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-24

• #6

一人3分