I have a problem with trying to print a report (from Valentina Studio) on Postgres.
The report prints Ok on SQLServer. The query is simple:
SELECT wteSurname, wteName, wteClockCard,wteDepartment, wteCode from wtEmployee
I have 2 sort fields on the report: wteSurname, wteName.
When I am trying to print the report it shows the following:
SELECT * FROM ( SELECT wteSurname, wteName, wteClockCard,wteDepartment, wteCode from wtEmployee) as foo ORDER BY "wteSurname","wteName"
and
ERROR: column "wteSurname" does not exist
Where does "foo" come from? why is the query warped in this way? Should I do something differently?