Re: Normalization w/ MySQL?

[James Manning]

[ Wednesday, October  6, 1999 ] Dan Nelson wrote:
> As for deleting orphan records (say you remove a customer record and
> want all their chopping-cart items removed), you can either remove
> child records at the time of deletion, or have a nightly cron job that
> goes through and removes all orphan records en masse.

So what would this look like? a LEFT JOIN initial query then DELETE's?
or could it be done with a single delete?

James
-- 
Miscellaneous Engineer --- IBM Netfinity Performance Development