When executing a query, which contains a WITH clause and a LEFT OUTER JOIN, and publishing the results to a TIC (Toad Intelligence Central) server, an "ORA-00942: table or view does not exist" error is returned.
Here is an example of a query that would have this issue.
WITH T1 AS
(
SELECT * FROM DUAL
),
T2 AS
(
SELECT * FROM DUAL
)
SELECT *
FROM T1
LEFT OUTER JOIN T2 ON T1.DUMMY = T2.DUMMY
