How to delete statement by joining two tables?

[gowtham83]

TableA

id programid customerid
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
6 2 3
7 3 1
8 3 2
9 3 3



TableB

programid customerid
1 1
2 2


I want to delete values in TableA where values do not match in TableB

ex: for 1st row in TableB -- row no 2 and 3 in TableA should be deleted
ex: for 2nd row in TableB -- row no 4, and 6 in TableA should be deleted
Programid 3 in TableA will not be deleted.

I want a Delete statement to join TableA and TableB and delete values in
TableA

[deepak n]

Try the following delete statement:

delete from t1 where t1.id in (select t1.id from t1,t2 where t1.pid =t2.pid and t1.cid<>t2.cid)