>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.