如何写 Sql 语句(50分)

X

xywen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-05

• #1

有如下两个数据库：
A：
PCODE1，PCODE2
100 100100
B：
PCODE NAME
100 CCCCC
100100 BBBBB

如何查询A使它得到相对于B的NAME：
如下结果
CCCCC BBBBB

 

L

liuly

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-05

• #2

差不多应该是这样：
select a.name,b.name from 表A c, 表B a, 表B b where c.pcode1=a.pcode and c.pcode2=b.pcode
你试试吧！

 

S

Seoul_BJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-05

• #3

select newa.name name1,newb.name name2 from (select b.name from a,b where b.pcode=a.pcode1) newa,(select b.name from a,b where b.pcode=a.pcode2) newb

 

W

wind2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-05

• #4

agree Seoul_bj

 

X

xywen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-09

• #5

接受答案了.