>You can get the same result using correlated subquery

>SELECT menu.* FROM menu  ;
>	JOIN MenuOptions mo ON mo.NoMenu = menu.NoMenu AND mo.Enabled ;
>UNION ;
>SELECT menu.* FROM menu  ;
>	JOIN MenuPriviledge mp ON mp.NoMenu = menu.NoMenu AND mp.notype = lnNotype ;	
>	WHERE NOT EXISTS ( SELECT * FROM MenuOptions mo WHERE mo.NoMenu = menu.NoMenu)
>

Actually, this was my initial approach. But, I wasn't sure exactly how to make reference to Menu from the NOT EXISTS syntax.