SQL 主表全部显示,判断子表是否有记录,如有TRUE否则FALSE
SELECT --a.YnUse,
(select case when (SELECT isnull(b.FID,0) FROM dbo.tbUserPermission b
WHERE a.MID = b.MenuID AND a.FID = b.MID AND a.FunID = b.FunID
-- and b.UID = 44 and a.MID=904 )>0 then
原创
2012-07-03 10:32:51 ·
925 阅读 ·
0 评论