Sql Azure Simple Query running issue

  • 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


    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.

  • Do the two table schema compatible for a UNION?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply