union of 4 queries

[billybrag]

how would i union 4 queries together? ie something like

SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS1
UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS2
	UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS3
	UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS4
	UNION

Thanks

btw i realise the above wont work - its just to illustrate my idea

[guido2004]

how would i union 4 queries together? ie something like

SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS1
UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS2
	UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS3
	UNION
SELECT Title, CAST(PUBLISHEDDATE as date) as publisheddate, rsslink, content
	FROM RSS4
	UNION

Thanks

btw i realise the above wont work - its just to illustrate my idea

Except for the last line (get rid of that last UNION after RSS4), it should work just fine

[billybrag]

lol - excellent, that was easy

Ok, to mix it up a bit, is it easy to select the latest from each of the 4 feeds, then combine it?

so i would end up with 4 results?
edit - thanks btw

[guido2004]

Do a

ORDER BY PUBLISHEDDATE DESC
LIMIT 1

on each of the four selects.

[billybrag]

ah crud, cant use limit, dammit. This is a coldfusion thing. nothing is easy

[guido2004]

I don't know anything about coldfusion, but why can't you use LIMIT? Aren't you using MySQL?

[r937]

i really have to ask this: why do you have 4 separate tables? they look like they all have the same kind of data!!!

[billybrag]

its for a "query of queries" thing in coldfusion, so its not in essance 4 tables....

QofQ uses a subset of mysql in which limit is not included

[r937]

okay thanks

by the way, coldfusion's query-of-query does not use a "subset of mysql"

[billybrag]

ok, it uses a subset of SQL

When you query an existing query, you can use a subset of SQL statements, functions, and operators.

...from Adobe live docs