>>Try,
>>

>>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 ;	
>>	LEFT JOIN MenuOptions mo ON mo.NoMenu = menu.NoMenu  ;
>>	WHERE mo.Enabled IS NULL
>>

>
>It is amazing to see how you can view this so simply. It never occured to me to make use of the null approach to resolve this issue. Thanks a lot, this is exactly what I was looking for.

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)