I got a mail from Stephen Drew where he explained that my SQL was wrong and he also wrote how i should do an UNION ALL with GROUP BY.
The following text is taken from Stephens mail that i received: > An order by for the whole UNION should be: > > SELECT test1 FROM > ( > SELECT test1 FROM table1 > UNION ALL > SELECT test1 FROM table2 > ) > ORDER BY test1;
Thanks!
Ps. Sorry for posting my question twice but i got an error from "my" SMTP server.
-- Best regards, Andox
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
