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
Query:

SELECT name_mnu
FROM menu m1
WHERE name_mnu IS NOT NULL
UNION
SELECT parent
FROM menu m2
WHERE name_mnu IS NULL
ORDER BY name_mnu

RESULTS:

About
Contact
Education
Entertainment
HOME
Kid's Place
Kids
Login
Press Room
Sponsors
Ticket/Events
Trash art


Nick

nick, i was gonna give your query a try, and then i took a look at your data

something seems really, really wrong

could you please explain the purpose of each column

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

Nick