troubleshooting Question

How to define table aliases

Avatar of Dovberman
DovbermanFlag for United States of America asked on
Oracle Database
15 Comments5 Solutions374 ViewsLast Modified:
select letter FROM TableA  
     where letter =  
      (select letter from TableA z,
          TableC y, TableB a, TableA w, TableD a    
          where y.Col2 = a.Col2  
          and z.Col1 = y.Col1  
          and letter_type = 15) and letter_type = 15
          and x.Col2 = a.Col2
          and x.Col1 = w.Col1
        and rownum < 6)

Error: ORA-00904  "w.Col1 " :  invalid identifier

Evidently I have incorrectly defined table aliases.
What have I missed?

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 5 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros