Here's some info on doing it in MS-SQL. From Help on "FROM":
<table_source>
Specifies a table or view, both with or without an alias, to use in the
Transact-SQL statement. A maximum of 256 tables can be used in the
statement. A table variable may be specified as a table source.
If the table or view exists in another database on the same computer running
Microsoft® SQL Server(tm), use a fully qualified name in the form
database.owner.object_name. If the table or view exists outside the local
server on a linked server, use a four-part name in the form
linked_server.catalog.schema.object. A four-part table (or view) name
constructed using the OPENDATASOURCE function as the server part of the name
also may be used to specify the table source. For more information about the
function, see OPENDATASOURCE.
-----Original Message-----
From: Shark [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 1:20 PM
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
