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
>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
2 matches
Mail list logo