Re: SQL question; Please Help!

delete from t1 where (a,b) in (select a,b from t2);

-- 
Kind reGards,

Gerard
(ghp_at_santens.be; ghp_at_skynet.be)

Ivan Tung <ivant_at_direct.ca> schreef in artikel
<62hjf0$49l$1_at_brie.direct.ca>...


> I have 2 identical tables structures t1, t2.

> I essentially want to do an insert and update on t1 from t2.

> I plan to delete all rows in t1 that exists in t2 then insert all the

 rows


> in t2 into t1.

> The deleting is where I am having trouble.