Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ordered count(*) FROM T1, T2, T3
- WHERE T1.col1=T3.col11
- AND T2.col1=T3.col12
- AND T1.col2=1
- ORA-00923: FROM keyword not found where expected
- 00923. 00000 - "FROM keyword not found where expected"
- *Cause:
- *Action:
- Error at Line: 4 Column: 20
- SELECT ordered, count(*)
- FROM T1 join T2 on T1.col1=T2.col1
- join T3 on T2.col1=T3.col12
- WHERE T1.col1=T3.col11
- where
- T1.col2=1
- group by ordered
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement