a guest Jul 19th, 2019 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ordered count(*) FROM T1, T2, T3
  2. WHERE T1.col1=T3.col11
  3. AND T2.col1=T3.col12
  4. AND T1.col2=1
  6. ORA-00923: FROM keyword not found where expected
  7. 00923. 00000 -  "FROM keyword not found where expected"
  8. *Cause:    
  9. *Action:
  10. Error at Line: 4 Column: 20
  12. SELECT ordered, count(*)
  13. FROM T1 join T2 on T1.col1=T2.col1
  14. join  T3 on T2.col1=T3.col12
  15. WHERE T1.col1=T3.col11
  16. where
  17.  T1.col2=1
  18. group by ordered
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand