var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alternative of not in clause ???
Select * from Menu
Where Menu.MenuId Not In (Select Distinct MenuId from MenuByRoles)
is there any other way to write above query ?? i don't want to use
Not in clause
NOT EXISTS, EXCEPT, create a table that has the list of menuid's that do not exist in menubyroles table and then use IN.
Originally Posted by amitwadhawan123
From Menu M
Left Outer Join MenuByRoles MBR
On M.MenuId = MBR.MenuId
Where MBR.MenuId is NULL
Select * from Menu a
Where not exists (Select Distinct MenuId from MenuByRoles b where a.MenuID = b.MenuID)
what do you think would happen if you removed the DISTINCT?
Originally Posted by PMASchmed
i know, i know... pick me!!!!