[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