INNER JOIN ON TWO DATABASES

• kkingma

  Newbie

  Points: 9

  More actions

  March 15, 2007 at 11:06 am

  #68468

  Hi:

  I have a VB 2005 application that has two separate SQL Server 2005 databases in the application folder (Fees.mdf and Schedules.mdf).

  I want to do an inner join on two tables: one table is in the Fees database and the other is in the Schedules.

  In SQL Server 2000, I could write a stored procedure to do this:

  SELECT A.CODE, B.Fee FROM Fees.dbo.Codes A

  INNER JOIN Schedules.dbo.ScheduleFees B ON A.Code = B.Code

  But this doesn't work in SQL Server 2005 express (since the databases aren't attached to a server per say). Can anyone help?

  Thanks in advance!

  Kevin

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  October 17, 2007 at 4:19 am

  #742649

  What exactly do you mean by "aren't attached to a server"? Isn't the database engine installed on your machine?

  The Express edition is in this regard no different from any other edition of SQL Server 2005. Perhaps you should explain your problem in more detail.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com