From: ron.heeb@csun.edu (Ron Heeb) Subject: real beginner PL/SQL question Date: 1996/11/11 Message-ID: #1/1 organization: CSU, Northridge Network & Computing Services newsgroups: comp.databases.oracle 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@csun.edu, webmaster@csun.edu