这条sql语句怎么写？(50分)

I

iranjn

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #1

有3个表t1,t2,t3.
t1表有‘卡号’，‘合同号’字段
t2表有‘卡号’，‘金额’字段
t3表有‘合同号’，‘电话’字段
用什么SQL 语句可以同时显示这几个字段（有公共字段）

 

X

xzh2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #2

select t1.卡号，t1.合同号,t2.金额,t3.电话
from t1.卡号=t2.卡号 and t1.合同号=t3.合同号

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #3

select a.卡号,a.合同号,b.金额,c.电话
from t1 a,t2 b,t3 c
where a.卡号=b.卡号
and a.合同号=c.合同号;

 

Z

zikao419

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #4

select t1.卡号，t1.合同号，t2.卡号，t2.金额，t3.合同号,t3.电话 from t1,t2,t3 where
t1.卡号=t2.卡号 and t1.合同号=t3.合同号

 

C

chinaluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #5

select t1.卡号，t1.合同号，t2.卡号，t2.金额，t3.合同号,t3.电话 from t1,t2,t3 where
t1.卡号=t2.卡号 and t1.合同号=t3.合同号
我也是这样认为的,.

 

L

lb_icesea79

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #6

select t1.卡号，t1.合同号，t2.卡号，t2.金额，t3.合同号,t3.电话 from t1,t2,t3 where
t1.卡号=t2.卡号 and t1.合同号=t3.合同号
我也是这样认为的,.

 

H

hdy_2002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #7

select t1.卡号，t1.合同号，t2.卡号，t2.金额，t3.合同号,t3.电话 from t1,t2,t3 where
t1.卡号=t2.卡号 and t1.合同号=t3.合同号
我也是这样认为的,.

 

B

blackbook

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #8

有3个表t1,t2,t3.
t1表有‘卡号’，‘合同号’字段
t2表有‘卡号’，‘金额’字段
t3表有‘合同号’，‘电话’字段

select * from t1 as a left join t2 as b on b.卡号=a.卡号
left join t3 as c on c.合同号=a.合同号

 

春

春意

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-28

• #9

select a.卡号,a.合同号,b.金额,c.电话
from t1 as a inner join t2 as b
on b.卡号=a.卡号
inner join t3 as c on c.合同号=a.合同号

 

I

iranjn

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-31

• #10

多人接受答案了。