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