This query produces a list of names(RESULTS) which correctly includes two parent(s) by virtue of the union. What I need now is to eliminate the name "Kids" from RESULTs because "Kids" are replaced by the two name_mnu results.
Logic: List all "parent" and all "name_mnu" (as parent) but filter out and parent whose name_mnu is not null. See attachment:
This will be a menu list of pages (parent) where if the page has
FROM menu m1
WHERE name_mnu IS NOT NULL
FROM menu m2
WHERE name_mnu IS NULL
ORDER BY name_mnu
The Results list is is a list of pages in a menu system for a web site. In the attachement you can see that KIDS (on parent) has two subordinate items which are sub-menu items. I need a list of all of parent where name_mun IS NULL, and all of name_mnu where name_menu IS NOT NULL, ordered alphabetically.
So RESULTS which not have KIDS and I would like to name the resulting column "CSSMENU".