RE: [SQL] How to delete multiple instances

.id In the above case we delete matching rows just from tables t1 and t2. -Original Message- From: Juergen Schreck [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:06 AM To: MYSQL List Subject: [SQL] How to delete multiple instances Hi, I'm wondering what the best w

[SQL] How to delete multiple instances

Hi, I'm wondering what the best way is to remove multiple records matching against multiple instances found in another table. I'd like to avoid using a scripting solution doing this in a loop. Let's say I have two address books and there is some cross-over in entries. I want to delete from addre

[SQL] How to delete multiple instances

Hi, I'm wondering what the best way is to remove multiple records matching against multiple instances found in another table. I'd like to avoid using a scripting solution doing this in a loop. Let's say I have two address books and there is some cross-over in entries. I want to delete from addre