Azure - Multiple database queries

Question

How can I query multiple tables from multiple azure databases?

Imagine I have "customers" table in Database X and "sales" table in dabtabase Y and I want to join them in a query, how is it possible to do this in Azure?

Just to clarify: Are you specifically talking about Azure SQL Database service? — David Makogon, Jan 24 '15 at 02:54
possible duplicate of [Can't Query between Databases in SQL Azure](http://stackoverflow.com/questions/11284998/cant-query-between-databases-in-sql-azure) — user272735, Jan 24 '15 at 11:08

score 0 · Answer 1 · answered Jan 24 '15 at 02:55

Assuming you're talking about Azure's SQL Database service, then no, you cannot have queries across two separate database instances. The queries are limited to the single database.

If you require queries spanning multiple databases, you'd need to install SQL Server on a VM.

score 0 · Accepted Answer · answered Jan 24 '15 at 05:07

David is correct -- currently Azure SQL DB doesn't support cross-database joins.

Is it possible for you to combine the two databases into a single DB, but use separate schema to keep the namespaces of objects separate? I am curious about the business reasons you are maintaining separate dbs. You can reach out to me directly at Stuarto Microsoft com.

score -3 · Answer 3 · answered Jan 24 '15 at 01:55

-3

You can join them if they're hosted on the same server. Try this

SELECT a.userID, b.usersFirstName, b.usersLastName  FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b  ON a.userID=b.userID

answered Jan 24 '15 at 01:55

Waseem Hassan

233
2
10

If the OP is referring to SQL Database service, this cannot be done. – David Makogon Jan 24 '15 at 02:56
While this is valid for SQL Server, it cannot be done in Azure. – Three Value Logic May 04 '15 at 14:58

Azure - Multiple database queries

3 Answers3