CODEWITHSUNDEEP
sqloracle-databaseora-00933
user235693
user235693

Reputation: 371

SQL Inner join on select statements

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

select *
from (select* from bars  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!

Upvotes: 23

Views: 87955

Answers (4)

stud
stud

Reputation: 11

just give a whitespace between ')' and 'as':

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

Upvotes: 1

Ozan BAYRAM
Ozan BAYRAM

Reputation: 2901

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

Upvotes: 1

Wade73
Wade73

Reputation: 4509

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

Upvotes: 2

Egor Rogov
Egor Rogov

Reputation: 5388

Just remove as from your query:

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

Upvotes: 56

Related Questions