Hi, i have a problem with using union and group by together.
SELECT * FROM `table1` UNION SELECT * FROM `table2` WHERE metal = '1' GROUP BY width
this returns in my dropdown:
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?