Skip to content
Advertisement

How to query across multiple databases

I have a set of data that belongs to two different tables in two different databases. I have performed the query but I am getting a syntax error.

The two databases are:

This is what I am doing:

Why would it give me an error on this part?

as the syntax appears correct

Any help is appreciated.

Advertisement

Answer

This Back.[dbo].Back$.Last_refreshed, does not make sense. You can still use databasename.schemaname.columnname or a four part name (if you set up linked servers… instancename.databasename.schemaname.columnname), but it is not clear what you are referring to with: Back.[dbo].Back$.Last_refreshed

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement