Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

syntax error: SQL Error: ORA-00907: missing right parenthesis

1006212May 1 2013 — edited May 1 2013
Hello dear friends

I have a query in Oracle 11g, and i get this error :
SQL Error: ORA-00907: missing right parenthesis

SELECT F.CountryOfInterest, SUM(F.PopulationNum) as NeighborTotal from  
(SELECT CB.CountryOfInterest, CB.BorderCountry, C.PopulationNum from 
	(SELECT Country1 as CountryOfInterest, Country2 as BorderCountry from Borders
 UNION
	SELECT Country2 as CountryOfInterest, Country1 as BorderCountry from Borders)
  as CB,Country C where CB.BorderCountry = C.Name)
  as F group by F.CountryOfInterest;
what is the problem?



thank you in advance.

best
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2013
Added on May 1 2013
3 comments
4,746 views