Using the below as an example:
WITH V_TBL1 (ID,NAME) AS (SELECT ID,NAME FROM TABLE1), V_TBL2 (TIME) AS (SELECT TIME FROM TABLE2 WHERE TABLE2.ID IN (V_TBL1.ID)) SELECT * FROM V_TBL2 ;
Why does Oracle throw the error?
-- *V_TBL1.ID: Invalid Identifier* line 3
I'm sure I've used this before and it's worked, I can't see what I'm doing wrong this time.