[RESOLVED] Howto shorten this down !?!

[jara06]

The topic says it all ... This is basicly the result I want, but there has to be a better way ....! ?.... :o

(SELECT a.id as aco_id, 'gallery' as table_name, g.name FROM tblACO a INNER JOIN tblGallery g ON (a.id=g.aco_id) WHERE a.approved = 1)
UNION
(SELECT a.id as aco_id, 'documents' as table_name, d.title FROM tblACO a INNER JOIN tblDocuments d ON (a.id=d.aco_id) WHERE a.approved = 1)
UNION
(SELECT a.id as aco_id, 'weblogs' as table_name, w.title FROM tblACO a INNER JOIN tblWeblogs w ON (a.id=d.aco_id) WHERE a.approved = 1)

[coreyp_1]

I don't see a better way, since you want fields from different tables to end up under the same column heading.