Naomi,

>Sorry, it's an old thread, but you should have used INNER JOIN for your delete statement and then it would have worked. I'm wondering if there is any valid reason to ever use LEFT JOIN while doing a DELETE.

As a way around not having TRUNCATE rights? *wg*