[thelist] Multiple Database Union?
Russ
russ at unrealisticexpectations.com
Fri Mar 19 11:45:22 CST 2004
Hi all,
I've got a page where we'd like to do a union from multiple databases on
the same server, using ColdFusion MX and MySQL.
Something like this:
Select Title, Story, Date, Time and commentCount
from database1.tblName
Union
Select Title, Story, Date, Time and commentCount
from database2.tblName
union....
The issue at hand is that I'm unsure how to query across databases--more
specifically how to specify the database in the FROM clause.
Does anyone have any insight?
Thanks,
Russ
More information about the thelist
mailing list