delete records which are related to another table
I want to delete some records from a table(A), these records has some relationship with another table(B)
using a query to define these A records that i want to delete
with B as
(
select '2' f, '3' l from dual
union all
select '3' f, '2' l from dual
union all
select '4' f, '4' l from dual
)
select * from A, B
where B.f>3 and B.l>3
and A.f=B.f
and A.l=B.l
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Thanks in advance!