Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Mauro.
Asked: December 15, 2016 - 8:01 am UTC
Last updated: December 16, 2016 - 2:36 am UTC
Version: 11.2.0.4
Viewed 1000+ times
SQL> SELECT * 2 FROM t2 3 JOIN t4 USING (z); JOIN t4 USING (z) * ERROR at line 3: ORA-00904: "T2"."Z": invalid identifier
SQL> SELECT * 2 FROM t1 3 JOIN t2 USING (x) 4 JOIN t4 USING (z) 5 JOIN t3 USING (y); JOIN t4 USING (z) * ERROR at line 4: ORA-00904: "from$_subquery$_003"."Z": invalid identifier
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!