When using advanced SQL queries, is it possible to join to the same table more than once? Normally in SQL I'd just use an "as" to alias the table differently for each instance, but OutSystems doesn't seem to like the "as" keyword.
For example, if you've got a static entity with simple "Yes / No / NA" options, and an entity with several different columns all joining to that table, but you can't use an aggregate because the filtering criteria for the data is too complicated.
The main objective of Advanced SQL is to give us the same platform as the SQL Does.