In MySQL you can't update on a join. It's a real pain in a well-factoreddatabase.
-Michael Robinson
P.S. When it comes to ROLAP, though, MySQL kicks PostgreSQL's butt. For thatapplication only, I use MySQL.