I'm having trouble creating a view in cache with query like:
SELECT column1, column2, column 3
(column1, columnn 2) IN (SELECT c1, c2 FROM table2 GROUP BY c1)
ORDER BY column1
I think the problem is in where clause, because it cannot take two columns .
the exact error: [SQLCODE: <-1>:<Invalid SQL statement>] [%msg: < ) expected, , found^ (column1,>]
Any idea on how to solve this?