Reymelito If you have an example of an update on two tables I'd be interested in seeing it. Let me have the example or link and I'll have a proper pop at this. From http://dev.mysql.com/doc/refman/5.1/en/subquery-restrictions.html: >>In general, you cannot modify a table and select from the same table in a subquery Which rules out one option... My preferred appoach would still be transactions since it will be much more maintainable/readable. Here's an old thread on that http://www.codeguru.com/forum/showthread.php?t=371117&highlight=auto-commit Cheers Dave
Data Quality Tools
