BorlandTalk.com

Bpk. Adi Wira Kusuma · Guest

I ask to you. How to delete data at table A that exist at table B.
Usually I write like this:

DELETE FROM TA where NOID in (SELECT NOID FROM TB).

But it can works, if at table A (TA) has 1 field to be primary key. If table
A (TA) has 4 fields to be primary key. How its syntax so good?

Bill Todd · Guest

DELETE FROM TA
where EXISTS (SELECT SELECT 1 FROM TB
WHERE TA.PK1 = TB.PK1 AND TA.PK2 = TB.PK2)

--
Bill Todd (TeamB)