> Hi, I'm wondering if it's possible to make a join over 2
> different databases
> on 2 different servers. What I'm trying to do is that I have my
> information
> on 1 server, including a customer id and the customer name is
> located on the
> other server. I can easily get all this info in multiple queries, the
> problem doesn't arise until I want to be able to sort on the
> customer name.
> It's 2 MS SQL servers. Does anyone know if this is possible, maybe in TSQL
> or similar ?
You really need the Query a Query functionality in CF5
But - as long as the SQL Servers can see each other, then it's fairly easy
across databases
Select t1.*, t2.*
from Server.Database.dbo.Table as t1, Server.Database.dbo.Table as t2
The "dbo" is the database owner, so if they've been created under a
different SQL user, then you'll have to use that instead
Give it a try
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
