How do i combine these two querys:

1: "SELECT * FROM submenu WHERE submenu.parent NOT IN (select id from topmenu) UNION
SELECT * FROM topmenu"
2: "SELECT * FROM topmenu"

And echo them out in a loop ?

hi..
i do like this:

"select a.*,b.* form table1 a,table2 b where (condition)"

i never use union command

and if u want to echo them in a loop
try to use while loop..
because i use to do it ,and it work great



..sorry if this not help you

I'd say that your first query already does that.
The UNION statement is used to join the result of 2 queries, and the 2 queries you join are
1)SELECT * FROM submenu WHERE submenu.parent NOT IN (select id from topmenu)
and
2)SELECT * FROM topmenu

So, in the result of that query:

SELECT * FROM submenu WHERE submenu.parent NOT IN  (select id from topmenu)
union
SELECT * FROM topmenu

, and as far as the type and numbers of columns are the same, you will get every rows from topMenu, and every rows from subMenu who does not have a parent defined in topMenu.