Steven Rosenstein wrote:> DELETE FROM detail JOIN summary ON (summary.id=detail.sum_id) WHERE> collect_date='2005-02-05';
DELETE FROM detail WHERE detail.sum_id in ( select id from summary )AND collect_date='2005-02-05';
RegardsGaetano Mendola