rookie deleting records
From: Tim Downs <tim.downs_at_thedacare.org>
Date: Mon, 28 Feb 2000 16:12:53 -0600
Message-ID: <38BAF2E5.4A02F69F_at_thedacare.org>
[Quoted] [Quoted] I'm trying to delete records from a table based on another table and can't seem to get it to work. I can select the records I want to delete using the following syntax but I can't seem to get the delete syntax to work.
Date: Mon, 28 Feb 2000 16:12:53 -0600
Message-ID: <38BAF2E5.4A02F69F_at_thedacare.org>
[Quoted] [Quoted] I'm trying to delete records from a table based on another table and can't seem to get it to work. I can select the records I want to delete using the following syntax but I can't seem to get the delete syntax to work.
select reqline.req_number, reqheader.req_number
from reqline, reqheader
where rewline.req_number = reqheader.req_number(+)
and reqheader.req_number is null;
tia
Tim Received on Mon Feb 28 2000 - 23:12:53 CET