当count值为0的时候
select count(a.sys_unitguid),a.sys_unitguid
from wyun_sys_unitinfo a ,wyun_sys_unitinfo b
where a.sys_unitcode = b.sys_unitparent
and a.sys_unitguid = '00000119C69B9B4D004B372D5A8354EE'
group by a.sys_unitguid
没有返回值
去掉group by
select count(a.sys_unitguid)
from wyun_sys_unitinfo a ,wyun_sys_unitinfo b
where a.sys_unitcode = b.sys_unitparent
and a.sys_unitguid = '00000119C69B9B4D004B372D5A8354EE'
着返回"0"请教高,我想要 0 XXguid 这样的结果要怎么处理啊....
from wyun_sys_unitinfo a ,wyun_sys_unitinfo b
where a.sys_unitcode = b.sys_unitparent
and a.sys_unitguid = '00000119C69B9B4D004B372D5A8354EE'
group by a.sys_unitguid 这样试试!