Query Builder - database names dropped from the generated sql

Hiya

I am creating joins between tables in two databases - so connecting databaseA.dbo.table1 to databaseB.dbo.table2

Everything works except that when the sql is generated it does not contain the database name when listing the FROM statements.

eg it will just say

FROM   dbo.table1, dbo.table2

I then have to add the database names in manually.

Is this the expected funtionality?

Many thanks!

Jon Cheyne


       

Hi Jon, We'll have a look at this. Which database are you using? Best regards, Hans

Ms SQL Server, client running on Ubuntu ...