RadSystems 8.7.0, SQLSTATE[42000]: Syntax Error Or Access Violation: 1066 Not Unique Table/Alias:
ListPage :
if we have more then 1 column, related to same table → generated result alias name generated same alias table both of related table
example:
Select Count(*) As Aggregate From Mstrain
Inner Join Mslocstation
On Mstrain
.Traoriginstationid
= Mslocstation
.Lsid
Inner Join Mslocstation
On Mstrain
.Tradeststationid
= Mslocstation
.Lsid