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