MySQL学习中,求一个语句的写法

Submitted by libftx on 周一, 2008/08/11 - 17:10

新手,求以下语句该怎么写?谢谢了!

表A:
id name
1 aaa
2 bbb
3 ccc

表B:
no agent_id shipper_id
1 1 3
2 2 3
3 2 1

要求得到结果:
no agent_name shipper_name
1 aaa ccc
2 bbb ccc
3 bbb aaa

Taxonomy upgrade extras:

yejr

周二, 2008/08/12 - 09:40

参见手册的 LEFT JOIN 语法

MySQL方案、培训、支持

游客 (未验证)

周二, 2008/08/12 - 11:12

select
b.no, a.name as agent_name, c.name as shipper_name
from
tableb as b
left join
tablea as a on b.agent_id = a.id
left join
tablea as c on b.shipper_id = c.id

libftx

周二, 2008/08/12 - 17:12

测试通过!
谢谢回复!

游客 (未验证)

周二, 2008/08/12 - 11:13

select
b.no, a.name as agent_name, c.name as shipper_name
from
tableb as b
left join
tablea as a on b.agent_id = a.id
left join
tablea as c on b.shipper_id = c.id