Re: real beginner PL/SQL question

Try it:
delete from B
where ID not in
(select ID
from A);

But it may be slow.

-- 
---
Damian Golda


Ron Heeb <ron.heeb_at_csun.edu> napisa³(a) w artykule
<ron.heeb-1111961630420001_at_rheeb.csun.edu>...


> how do i delete rows that are in one table but not in the other?  i.e.


> table A has id's of 1,2,3,4,7,8 and table B has 1,2,3,4,5,6,7,8; how do i

> identify and delete 5 and 6 based on not existing in table A?  thanks in

> advance, ron

> 

> -- 

> Ron Heeb, Webmaster

> Mgr., Applications Development, ITR

> California State University, Northridge

> email: ron.heeb_at_csun.edu, webmaster_at_csun.edu

>