I’m trying to create a test report using data from a transaction group. When I use the SQL Query Builder and select the entire table, the query works fine.
When I select specific columns using the Builder, I get an error message about columns not existing. The columns do exist and there is no chance of a typo since the Builder created the query.
WARN: An error occurred while executing Query SELECT group_table.N7_0,
FROM group_table-- ERROR: column group_table.n7_0 does not exist
Hint: Perhaps you meant to reference the column “group_table.N7_0”.
What is the problem here? I don’t have much experience with sql queries, but it looks very simple and correct.