bdemeulder / PIONEERmetastaticTreatment

PIONEER 2022 studyathon characterization study
Apache License 2.0
2 stars 4 forks source link

Alias missing in SQL #9

Open marek05 opened 1 year ago

marek05 commented 1 year ago

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.