Yup - sure is (permissions permitting of course)
select ... from localtable inner join dbname.dbo.remotetablename on ...
replacing ... , localtable, dbname, remotetablename with appropriate...
HTH
Dan
-----Original Message-----
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 17:05
To: CF-Community
Subject: joining 2 tables in 2 different db's
<sql brain fart!>
is it possible to do a query joining 2 tables that are located in two
different databases, but on the same sql server?
ie: i need to bring in a customer_id from one table and insert it into
another table, i have their email address to join on
<is it friday yet?>
~~
Stephenie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
