[Zope] re: SQL Unions.

[Brenton Bills]

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?