SQLServer question

Results 1 to 2 of 2

Thread: SQLServer question

  1. #1
    Join Date
    Dec 1969

    Default SQLServer question

    Hi Expert<BR>I am using ASP and SQLServer.I have a number of Database say A,B,C etc.I am connecting with A db but I want to access only one table from B without connecting B.Is it possible or is there any mechanism to get data from table A.

  2. #2
    Join Date
    Dec 1969

    Default You can join database in one statement

    SELECT * FROM Server.DB_A.dbo.Table1 T1 <BR>INNER JOIN Server.DB_B.dbo.Table1 T2 on T1.ID = T2.ID<BR><BR>I believe that&#039;s proper syntax. Is there some reason you have all these different databases? Why not one database with different tables?<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts