试试这个 select ID,(select b.name from A,B where a.DAIMA01=b.DAIMA) as DAIMA01_NAME, (select b.name from A,B where a.DAIMA02=b.DAIMA) as DAIMA02_NAME from A
错了: select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME from a,b,b c where a.DAIMA01 =b.DAIMA and a.DAIMA02 =c.DAIMA
select ID,(select b.name from A,B where a.DAIMA01=b.DAIMA) as DAIMA01_NAME,
(select b.name from A,B where a.DAIMA02=b.DAIMA) as DAIMA02_NAME
from A
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMA
and a.DAIMA02 =c.DAIMA
有什么更好的方法吗
CSDNM(CSDN管理员(假的) 方法查出来为空 :)
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMa
and a.DAIMA02 =c.DAIMA
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMa
and a.DAIMA02 *=c.DAIMA
from (a
left join b on a.DAIMA01 =b.DAIMa )
left join b c on a.DAIMA02 *=c.DAIMA