Sql Azure Simple Query running issue

• shubham.saxena67

  Default port

  Points: 1490

  More actions

  January 12, 2012 at 2:03 am

  #251276

  Dear friends,

  I am having two different database like 'LiveDB' and 'MFDB'

  both are having a common table named 'TB_Transaction'

  now i need to select all record that exist in both databases.

  when i run the following query:

  select * from LiveDB.Dbo.TB_Transaction

  union

  select * from MFDB.Dbo.TB_Transaction

  this gives an error.

  Reference to database and/or server name in 'livedb.dbo.tb_transaction' is not supported in this version of SQL Server.

  Plz tell me what is the alternate way to accomplish this task.

• mysorian

  Ten Centuries

  Points: 1048

  More actions

  June 10, 2013 at 2:03 pm

  #1622623

  Do the two table schema compatible for a UNION?