I created an interactive report based on a SQL-Query, I then wanted to insert another value from the table into this SQL query.
However, when I tried to do this I got the following error: ORA-00904: "D". "SPID": invalid ID.
I have already googled it and it says it could be because the wrong column name was entered or it would be solved if an alias was used, which I have already tried but still get the same error.
I have also run the SQL query in the SQL command and it shows me the correct result.
So what could be the cause of the error?