Yes, if your user has been granted read access to the tables in the other
db.
the logic is something like this.....
select name
from employee, otherdb.person
where email = otherdb.person.email
-george
>From: "Stephenie Hamilton" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Community <[EMAIL PROTECTED]>
>Subject: joining 2 tables in 2 different db's
>Date: Thu, 07 Jun 2001 12:04:53 -0400
>
><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
