Well, actually my query does not work.

Issue being the ovnd_key='13' insert into PRCR.

Without that insert, my query does not give desired results.

The above query seems to work fine.

🙂

I finally got it working as follows:

SELECT *

FROM ord1 H

WHERE EXISTS

(

SELECT NULL

FROM PRCR C1

WHERE C1.customer = H.customer

...

Is that still confusing?

Ok. Admit the typos.

1. In the insert for ord1, the value for sku_upc should be 'U' in all.

This eliminates query clauses to be altered.

2. zzeopdcr should...