Hi, i have a problem with using union and group by together.
the following:

PHP Code:
SELECT FROM `table1UNION SELECT FROM `table2WHERE metal '1' GROUP BY width 
this returns in my dropdown:

Code:
2
4
5
6
2
4
5
6
the group by seems to work but only for one table at a time.
i would like it to work with both tables so it should only display 2,4, 5,6.

Any Ideas why its not working correctly?

Regards
David