17 Jan
2000
17 Jan
'00
9:47 p.m.
Hi people, I have been attempting to do an SQL union from an ZSQL Method with MysqlDA as my back end database. The only problem is I cant seen to get it to work. Are unions a bad thing? Should I be using something else. Eg. Get all the brands we have in our database. select brand from tableofitemsoftype1 union select brand from tableofitemsoftype2 group by brand.
From what I understand this would get all of the brands and group them together and place them in a single column results table?