multiple datasources for cfquery
Posted on 2007-10-18
I have a cf query that pulls out from two databases (MS SQL 2000).
select empid, lname, fname, jobtitle, bla....
where jobtitle not like '%Regular%' and
empid NOT IN (select empidsev
where hirestatus not like '%term%')
order by empid, bla....
As you can see, there are two separate databases, EMPHRDB and EMPSEVDB.
In this case, what/how do you put for 'datasource' <cfquery name ="getempdemo" datasource ="????????">