594
社区成员
发帖
与我相关
我的任务
分享
select *
from u_buyTaskMx A
join u_mtrldef B on A.MtrlID=B.mtrlid
where B.handtype like 'B线产品>>B%'
and A.TaskID =27395
SELECT COUNT(u_buyTaskMx.MtrlID)
FROM u_buyTaskMx
INNER JOIN u_mtrldef
ON u_buyTaskMx.MtrlID = u_mtrldef.mtrlid
WHERE u_mtrldef.mtrlid IN (
SELECT mtrlid FROM u_mtrldef WHERE handtype LIKE 'B线产品>>B%'
)
AND u_buyTaskMx.TaskID = 27395