I have multiple with clause in my Oracle Report query. I am using each with clause in different UNIONS. It is working fine when running in database directly. However giving invalid table error in Oracle Report Builder. Below is the example:
with Q1 AS
(SELECT X FROM TABLE1),
Q2 AS
(SELECT Y FROM TABLE2)
SELECT X FROM TABLE1
UNION ALL
SELECT Y FROM TABLE2
Basically I am using one with clause in one query and another in second query.
Error is: table or view does not exist (Select Y FROM ==>TABLE2)