SQL Inner join on select statements

Just remove as from your query:

select *from (select* from bars  where rownum <= 10 ) tab1inner join (select * from bars  where rownum <= 10 ) tab2on tab1.close=tab2.close

sql oracle ora-00933

I believe the error comes from you needing a semicolon to end the statement. The select looks fine to me otherwise.

sql oracle ora-00933

select * from ((select* from bars  where rownum <= 10 )as tab1inner join (select * from bars  where rownum <= 10 )as tab2on tab1.close=tab2.close)

CodeHunter