Can we show data from two databases in the same SSRS Table

• nikhil_ambaye

  Old Hand

  Points: 370

  More actions

  June 7, 2008 at 4:40 am

  #183189

  Hi All,

  II wanted to know if it is possible to join tables in to databases in SQL 2005(They have a common field).

  eg Database-A =>

  Table - InfoA(id,name)

  Database-B =>

  Table - InfoB(id,CreationDate)

  So can I get a single select clause to have CreationDate and Name in a dataset?

  Also please let me know if we can show the data from two databases in a single SSRS table.

  TIA,

  Nikhil

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  June 7, 2008 at 6:04 am

  #825801

  Select CreationDate,Name From [Database-A].[UserName].InfoA Ta INNER JOIN [Database-B].[UserName].InfoB Tb

  ON Ta.id=Tb.id

  Is this what you require?

  let me know if you are helpfull with the above Query, if this is not that what you want then ignore.