Using cfquery to select from multiple datasources

I need to write an sql statement within a cfquery tag that pulls from two seperate datasources. But it's coming back with "Invalid object name " Below is the what I have written: SELECT townid as tid, town as cityname from towns where siteID = 1 union select distinct city as cityname from comp

Re: Using cfquery to select from multiple datasources

>Kristin Collins wrote: > >Does the user that you are connecting to the request.dsn with have >access to the compdb database? Are the two databases on the same server >or are the servers linked? > >You said "datasources" in your message, and you can't quer