Table name qualifying on joins

Hi, there is a problem when doing joins. When I select the joining fields in a pair of tables, the second table is quelified with TbleMane.dbo.TableName. For example:

Instead of petrored.dbo.tbl_Agents

I get

tbl_Agents.dbo.tbl_Agents

Any ideas?

Can you please post an example of what you have before you select the join, or the columns, I'm not sure I understand the sequence of your actions.

Let's say I have 2 tables: tbl_Agents and tbl_Order. tbl_Orders has a foreign key to tbl_Agents. When I type SELECT * FROM tbl_Agents JOIN,
I get a hint to join with tbl_Orders and a plus (+) sign inside which are the 2 fields that form the foreign key.

If I double click on these fields, the resulting statement would be:
SELECT * FROM tbl_Agents AS a
JOIN tbl_Orders.dbo.tbl_Orders AS o on a-ID_Agent = o.ID_Agent

Clearly, this is wrong.

Thank you. Which version are you running?

version 6.5.258

version 6.5.258

I'm able to reproduce this issue. This is clearly a bug. I have logged a high priority ticket #SA0022889 to have this issue fixed as quickly as possible.

Thanks. Where can I get updates on the process to fix bugs?

The software itself will notify you when a new update is available.

Thanks