At 04:04 PM 12/5/2004, Robert DiFalco wrote:

>Without using ON DELETE or Triggers, how can I best do the following?
>
> DELETE
> FROM Child JOIN Parent ON Child.F_ID = Parent.F_CHILD_ID
> WHERE Parent.F_FOO = 1;

That statement is not just illegal, it's ambiguous. Do you
delete the qualifying rows from PARENT, CHILD or both? Under
the rules of an inner join, CHILD join PARENT on <condition>
is the same as PARENT join CHILD on <condition>.


Regards,


Ann