Thanks Costa,
I tried that with a couple access databases but it refers to
c:/winnt/system32/ folder for the database so I went ahead and put the
access database in that folder the result was it works fine. But why does it
not use the DSN assigned? What am I doing wrong?
Thanks Again
-Mark :)
----- Original Message -----
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 1:03 PM
Subject: RE: SQL Joins with multiple databases
> Use the fully qualified table name:
>
> <database Name>.<owner>.<tablename>
>
> For example:
>
> use hr
> Select * from
> dbo.tblEmployees INNER JOIN
> hrdatabase2.dbo.EmployeeInfo ON
> dbo.tblEmployees.EmployeeID =
> hrdatabase2.dbo.EmployeeInfo.EmployeeID
>
> -----Original Message-----
> From: Shark [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 11:20 AM
> To: CF-Talk
> Subject: SQL Joins with multiple databases
>
>
> Anyone know a way to do joins using SQL on more than one database? Rather
> than scripting.
>
> Thanks, Mark
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
