SQL Inner join on select statements [duplicate]

This question already has answers here: Closed 10 years ago.

Possible Duplicate:

SQL Inner join on select statements

I am trying to make an inner join on a select statement like this:

select *
from (select* from b开发者_如何学Goars  where rownum <= 10 )as tab1
inner join (select * from bars  where rownum <= 10 )as tab2
on tab1.close=tab2.close

and I get the following error: ORA-00933 SQL command not properly ended Any help would be appreciated, thank you!

---

You don't have a space between "select" and "" in "select".