how do i delete the records [message #18755] |
Wed, 13 February 2002 07:10 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
I have some select statement like below...
Now what i want is to delete all the records which are fetched by this select statement,so how do i attach the delete statement to this.
(
select
C.ID as CSID
,
t1.bid as BID
,
t1.Cid as CID
from tab1 t1, Tab2 t2, Tab3 t3, tab4 t4, tab5 t5
where t5.FI_PARENT <> 0
and t5.FI_PARENT = t3.ID
and t5.FI_CHILD = t4.ID .......something like this more and conditions
group by t1......... some columns,
order by some columns.....)
|
|
|
|
Re: how do i delete the records [message #18760 is a reply to message #18755] |
Wed, 13 February 2002 08:03 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
in the query,finally after the select statement is executed,all the records are inserted into tab1.
So i want to delete from tab1 satisfying the select statement conditions...
|
|
|
|