You could do cross database queries even if they were on different servers. In the case of MSSQL, you just have to register linked servers through sp_addlinkedserver, and then use myLinkedServer.Mydatabase.MyDBuser.Mytable
.TofOn 9/13/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:Are the
Nothing wrong with cross-database joins - heaps quicker than a QofQ.
On 13/09/06, Barry Beattie [EMAIL PROTECTED] wrote:
Thanx Rod
well, bugger me, it worked!
cfquery name=qry datasource=FOUREX
SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID,
INST.AbsoluteSerialNum
FROM
Whats the database type your using?
and are botht he databases on the same server?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Barry Beattie
Sent: Wednesday, September 13, 2006 10:52 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Querying
Hi,
The query you have posted shows the correct syntax for using a table from a
different database. (i think I would add the server name too).
you could always create a view with the table inside of it.
[EMAIL PROTECTED] 13/09/2006 10:52 am
Hi all
I think I remember a post on this before
Thanx Rod
well, bugger me, it worked!
cfquery name=qry datasource=FOUREX
SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID,
INST.AbsoluteSerialNum
FROM evaluationsQuizDev.dbo.tbl_Quiz_Schedule AS SCHED INNER JOIN
tbl_InstrumentReleased AS INST ON