Delete with inner join on another table?
delete from tlc_driver2 DR2
inner join tlc_driver3 DR3
where DR2.EAN = DR3.EAN
and DR2.USER_ID = DR3.USER_ID
and NVL(DR2.CUSTOMER_ID, 'nlvdummy') = NVL(DR3.CUSTOMER_ID, 'nlvdummy')
and DR2.HIT_TIMESTAMP = DR3.HIT_TIMESTAMP;
Thanks
Tony