I have two tables. I attach a screenshot :
As you can see dbo.ANAGRAFICA_CLIENTI is master and dbo.ANAGRAFICA_RIFERIMENTI is detail. Relation between these two tables is established between field FK_CODCLI in detail and CODCLI in master. There is a foregin key between these two tables.
I open sql Editor and write a select statement :
code completion insert alias for master table and when I type - inner join - code completion suggest to me a wrong join condition. If I press return and insert it when I execute it I obtain an error message :
The condition of join isn’t correct - ON AR.CODCLI = AC.FK_CODCLI - . Code completion invert the aliases fields. The correct condition join is :
ON AC.CODCLI = AR.FK_CODCLI.
I stay tune for your consideration.