You shouldn't need that, you can do queries across SQL servers:
SELECT * FROM servername.databasename.owner.table.column
The servers of course have to be linked.
On Tue, 1 May 2001, Duane Boudreau wrote:
> You need CF5's Query a query feature for this
>
> -----Original Message-----
> From: Diana Nichols [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 1:52 PM
> To: CF-Talk
> Subject: JOIN queries from two datasources
>
>
> Sorry if this has been asked before....
>
> Can I join two queries from two different datasources (SQL 2000)?
>
> I need to relate the username/userID from source 1 to userID from source 2.
>
> (If it's too difficult, I'll just copy the username into source 2).
>
> TIA!
>
> D
>
> *************
> Diana Nichols
> Webmistress
> http://www.lavenderthreads.com
> 770.434.7374
>
> "One man's magic is another man's engineering." ---Lazarus Long
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
