Do you mean is there an equivalent in SQL Server to the 'relationship'
window you find in Access? If so then have a look at the 'diagram' option
for each database
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 11:45
To: [EMAIL PROTECTED]
Subject: RE: Linked Tables in SQL Server?
> Is there a way to "link" tables in SQL Server the way they can be
> in ACCESS?
> I mean in separate databases of course,
If you mean to a SQL database, you don't need to.
SQL Server will allow you to talk to other databases (even those without
ODBC DSNs);
select t1.*, t2.*
from table1 as t1, serverName.databaseName.dbo.tableName as t2
You can cut off the "serverName" part, it talks quite happily to other
databases as long as they are SQL Server
Philip Arnold
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.
**********************************************************************
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
