ORA-00907 Missing Right Parenthesis

[toilettenseife]

Good Morning,

I'm having issues with my joins. I'm getting an ORA-00907 Missing Right Parenthesis error with the following joins:

FROM First_Time_Removal_TSI_tbl TSIT INNER JOIN
((OSS_ADMIN.PO_MSTR POMH INNER JOIN OSS_ADMIN.REM_HIST RHIST2 ON (POMH.P_NBR = RHIST2.HS_REPAIR_ODR_NBR) AND (POMH.P_DTE_CLS = RHIST2.HS_REPAIR_DTE))
INNER JOIN OSS_ADMIN.RELIAB SIR ON POMH.P_CC = SIR.C_C)
ON First_Time_Removal_TSI_tbl.SI = POMH.P_CC;

Basically, I want to join the PO_MSTR table to a few other tables. I want to join it to REM_HIST by two fields; join it to RELIAB by one field; and join it to First_Time_Removal_TSI_tbl by one field.

The error says missing parenthesis but I have closed all my parenthesis. Any ideas on what the issue is?

Thanks!

 

[Norie]

Have you checked the rest of the SQL statement?

 

[toilettenseife]

Have you checked the rest of the SQL statement?

Yea, and I deleted all but the bare minimum to trouble shoot it down to the FROM clause. Working on rebuilding it now.

 

[Norie]

Rebuilding was bit by bit was what I was going to suggest next, good luck.

 

[xenou]

Not sure about Oracle but you may not even need parentheses in your join clause.