表AID XM NL
1 ZZZ QQ
2 FFF tt
表B ID AID SL
1 2 999
2 1 888求一语句实现如下ZZZ QQ 888
FFF tt 999SELECT XM,QQ,(SELECT b.SL FROM B where B.AID=A.ID) AS m FROM A,B
如上SQL语句问题在哪
1 ZZZ QQ
2 FFF tt
表B ID AID SL
1 2 999
2 1 888求一语句实现如下ZZZ QQ 888
FFF tt 999SELECT XM,QQ,(SELECT b.SL FROM B where B.AID=A.ID) AS m FROM A,B
如上SQL语句问题在哪
a.xm,a.nl,b.sl
from
a join b
on
a.id=b.id