getting the error in the below oracle query of inner join

Question

I am executing the below query in oracle but I am getting an error on the execution of the below query , Please advise how to overcome from this specially the error come when i add the last clause of where condition in the query

SELECT  t.product_name FROM JOBCODE_PROJECT_TYPE_MAPPING p
INNER JOIN AOBCODE_UCT_MAPPING h 
ON p.ID = h.jobcode_id
INNER JOIN WISK_UCTS t
ON h.risk_product_id = t.risk_product_id AND p.id = h.jobcode_id;
where p.sp_job_code= 'Add';

Usually, the error comes with an error message that may provide additional clues... — Jeffrey Kemp
– Jeffrey Kemp, Commented Jun 12, 2018 at 6:33

Ori Marko · Accepted Answer · 2018-06-11 15:38:02Z

2

Remove second duplicate condition AND p.id = h.jobcode_id; which is irrelevant in the join context:

  SELECT  t.product_name FROM JOBCODE_PROJECT_TYPE_MAPPING p
 INNER JOIN AOBCODE_UCT_MAPPING h 
 ON p.ID = h.jobcode_id
 INNER JOIN WISK_UCTS t
 ON h.risk_product_id = t.risk_product_id 
 where p.sp_job_code= 'Add';

answered Jun 11, 2018 at 15:38

Ori Marko

59.3k26 gold badges157 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting the error in the below oracle query of inner join

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related