select
a.xmmc,
c.xmmc as xmmc1,
b.name
from
sb_kjxm a
inner join
category b
on a.xkfldm=b.id
inner join
sb_kjxm c
on b.id=c.xkfldm1
a.xmmc,
c.xmmc as xmmc1,
b.name
from
sb_kjxm a
inner join
category b
on a.xkfldm=b.id
inner join
sb_kjxm c
on b.id=c.xkfldm1
select a.xmmc,b.name,c.name from sb_kjxm a,category b,sb_kjxm c
where a.xkfldm=b.id and c.xkfldm1=b.id
你的答案连一个结果集都没有,谢谢
select c.*,d.name2
(select a.xmmc as 'xmmc1',b.name as 'name1' from sb_kjxm a,category b where a.xkfldm=b.id) c
inner join (select a.xmmc as 'xmmc2',b.name as 'name2' from sb_kjxm a,category b where a.xkfldm1=b.id) d on c.xmmc1 = d.xmmc2
条件2 select a.xmmc,b.name from sb_kjxm a,category b where a.xkfldm1=b.id
----------------------------------------------------------------------------------
select a.*,b.name from
(select a.xmmc,b.name from sb_kjxm a,category b where a.xkfldm=b.id )a,
(select a.xmmc,b.name from sb_kjxm a,category b where a.xkfldm1=b.id )b
where a.xmmc = b.xmmc
where a.xkfldm=b.id and a.xkfldm1=c.id
union
select a.xmmc,b.name from sb_kjxm a,category b where a.xkfldm1=b.id