select count(T1.ID)
from REL_LHFUNC_TABLE T1,
FUNCTION_TABLE T2,
(select T3.ID
from LH_TABLE T3 left jion (SELECT * FROM CLOSED_TABLE WHERE PROJ_TYPE='LH') C on T3.ID = C.PROJ_ID
where c.PROJ_ID is null) k
WHERE T1.LH_ID = k.ID
AND T1.FUNC_ID = T2.ID
from REL_LHFUNC_TABLE T1,
FUNCTION_TABLE T2,
(select T3.ID
from LH_TABLE T3 left jion (SELECT * FROM CLOSED_TABLE WHERE PROJ_TYPE='LH') C on T3.ID = C.PROJ_ID
where c.PROJ_ID is null) k
WHERE T1.LH_ID = k.ID
AND T1.FUNC_ID = T2.ID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货