Start a new topic

Query Builder - database names dropped from the generated sql

[This topic is migrated from our old forums. The original author name has been removed]

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


       

[This reply is migrated from our old forums. The original author name has been removed]

Re: Query Builder - database names dropped from the generated sql
Ms SQL Server, client running on Ubuntu ...
[This reply is migrated from our old forums.]

Re: Query Builder - database names dropped from the generated sql
Hi Jon, We'll have a look at this. Which database are you using? Best regards, Hans