Hi, I want to combine to result-sets with 'union', but I don't know how to get the 'group by' right. I tried it like the example with 'order by' but that doesn't work. So I want to get something like: (select * from tab1) union (select * from tab2) group by column
How can I get this to work without subqueries? cheers, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]