Can not use Query Hints inside Azure SQL

Hey,

In an Azure project we are querying two remote databases and then joining them using an INNER JOIN.

The query takes rather long and analysing the query plan with SQL Management Studio showed that the problem is that a lot of data is transmitted from the two remote queries and then locally joined.

We now want to force the query to execute the join on the remote SQL server and then only transmit the resulting data.

For this I understood that the query hint “INNER REMOTE JOIN” can be used. But when trying to do so, the SQL server says that its current version does not support the REMORE parameter.

I understood it that way, that the Azure SQL always runs on the most current stable version of SQL Server, so why cant I use the Hint?