Request help from SQL Gurus
From: <gthorne777_at_my-deja.com>
Date: Thu, 27 May 1999 20:31:21 GMT
Message-ID: <7ika2p$86l$1_at_nnrp1.deja.com>
Hi, we are running RDB7. I'm not an SQL expert by any means, so I need help with this statement. I have two tables. We'll call them TABLE1 and TABLE2 for this example. I have rows in both tables that I want to delete based on a condition in TABLE1. For exaple, let's say TABLE1 has the following rows:
Date: Thu, 27 May 1999 20:31:21 GMT
Message-ID: <7ika2p$86l$1_at_nnrp1.deja.com>
Hi, we are running RDB7. I'm not an SQL expert by any means, so I need help with this statement. I have two tables. We'll call them TABLE1 and TABLE2 for this example. I have rows in both tables that I want to delete based on a condition in TABLE1. For exaple, let's say TABLE1 has the following rows:
DATE INTEGER
BATCH_ID INTEGER
DEST CHAR(8)
and TABLE2 has the following rows:
BATCH_ID INTEGER
DEST CHAR(8)
NAME CHAR(25)
ADDR CHAR(50)
ZIP CHAR(50)
PHONE CHAR(15)
I want to delete the records in TABLE1 before a certain date, and also delete the records in TABLE2 that have a corresponding BATCH_ID and DEST. What would be the easiest way to do this? I'm re-writing a
program that did it by doing a SELECT statement on the first table, parsing the output, and deleting the corresponding records in TABLE2. I think there has to be a better way.
-Greg
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu May 27 1999 - 22:31:21 CEST