Skip to Main Content

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!

ORA-02070 database does not support semi join in this context

798986Apr 5 2011 — edited Apr 5 2011
The following merge sql on Oracle 11g throws "ORA-02070 database does not support semi join in this context".

MERGE INTO ORDERS tgt
USING
(
SELECT C.short_name, C.customer_id
FROM customers C
WHERE customer_id IN ( SELECT distinct customer id FROM orders O WHERE O.order_date > SYSDATE - 3 )
)src
ON ( tgt.customer_id=src.customer_id )
WHEN MATCHED THEN
UPDATE SET tgt.short_name=src.short_name;

Any ideas? This piece of code was working on an earlier version of Oracle 11g.

Thanks,
Anu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2011
Added on Apr 5 2011
5 comments
2,263 views