On Wednesday, May 7, 2025, marcos sicat <
marcos.sicat@atlasifs.com> wrote:
I am running this query on v17 and generating the results, but not on v15.
In v15:
[Code: 0, SQL State: 42601] ERROR: subquery in FROM must have an alias
Hint: For example, FROM (SELECT ...) [AS] foo.
Position: 39 [Script position: 38 - 45]
Yes, we’ve since removed the requirement to assign the alias. If you need to run the query in v15 you will need to provide one.
David J.