You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In a join, If you need to preface an ambiguous field with a table name in a handwritten expression, you have to use the table alias, i.e. alias.FieldName. If the join order changes, the alias changes. It would be better to use TableName.FieldName, but once an alias is declared for a table, you can no longer reference the table by name.
There should be an option to turn table aliases off for joins. I'm not exactly sure at the moment where this would be passed, though.
The text was updated successfully, but these errors were encountered:
In a join, If you need to preface an ambiguous field with a table name in a handwritten expression, you have to use the table alias, i.e. alias.FieldName. If the join order changes, the alias changes. It would be better to use TableName.FieldName, but once an alias is declared for a table, you can no longer reference the table by name.
There should be an option to turn table aliases off for joins. I'm not exactly sure at the moment where this would be passed, though.
The text was updated successfully, but these errors were encountered: