Skip to content

Alias missing in SQL

Created by: marek05

I get following error:

Error: org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias Hint: For example, FROM (SELECT ...) [AS] foo. Position: 65

The SQL for charlson_map is missing an alias at line 745. Fix should be like 'select distinct * from (...) t; (at the moment 't' is missing).

I'm using PostgreSQL where it is mandatory to have these aliases.