select distinct m.Menu_CaptionC, m.Menu_ID from COM_MenuList m, COM_User_Permission p where p.MemberID='1' and m.Menu_ID!=p.Menu_ID试试看
select distinct Menu_CaptionC,Menu_ID from COM_MenuList a left join COM_User_Permission b on a.menu_id = b.menu_id where b.Menu_ID is null; 或 select distinct Menu_CaptionC,Menu_ID from COM_MenuList a left join COM_User_Permission b on a.menu_id = b.menu_id where b.Menu_ID = '';
select distinct m.Menu_CaptionC, m.Menu_ID from COM_MenuList m, COM_User_Permission p where p.MemberID='1' and m.Menu_ID!=p.Menu_ID这句应该就可以
from COM_MenuList a left join COM_User_Permission b
on a.menu_id = b.menu_id
where b.Menu_ID is null;
或
select distinct Menu_CaptionC,Menu_ID
from COM_MenuList a left join COM_User_Permission b
on a.menu_id = b.menu_id
where b.Menu_ID = '';