Re: Are JOINs allowed with DELETE FROM

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';


Regards
Gaetano Mendola