Cool, Thanks David!
-Mark :)
----- Original Message -----
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 11:56 AM
Subject: RE: SQL Joins with multiple databases
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
