Query between join database

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 6, 2006 at 1:45 am

  #167467

  Hi,

  I would like to make a query for to join two tables from two different database.

  How can I do for create en link between this database.

   

  Thanks

   

  ---

  Kindest Regards,

  degrem_m
  Degremont

• Usman Tanveer-239283

  Ten Centuries

  Points: 1104

  More actions

  March 6, 2006 at 2:17 am

  #624826

  I think following should work

  select A.*, B.*

  FROM DBA.dbo.TABLEA A INNER JOIN

          DBB.dbo.TABLEB B ON A.Id = B.FId