[Zope] re: SQL Unions.

Brenton Bills fud@mail.theinternet.com.au
Tue, 18 Jan 2000 07:47:07 +1000 (EST)


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?