2 个查询结果集怎么合并？

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 4218 days ago, the information mentioned may be changed or developed.

表结构
a:
aid

b:
aid | name

x:
xid

y:
xid | aid | value

SELECT a.aid,b.name FROM a join b on a.aid = b.aid

aid | name
1 | aaaa

SELECT x.aid,y.value FROM x join y on x.xid = y.xid

aid | value
1 | bbb

想得到结果，因为上面2个结果都有aid。

aid | name | value
1 | aaa | bbb

3 replies • 2014-10-13 21:22:16 +08:00

changsha

Oct 13, 2014 via iPhone

help

billlee

Oct 13, 2014

SELECT b.aid, b.name, y.value FROM b JOIN y ON b.aid = y.aid

moonkiller

Oct 13, 2014

我来找你了