I second this. Microsoft Access allows this as well and I was initially confused to learn this was not supported. Access allows performing joins in the table_specifier prior to the set_clause which makes table aliases far more useful as you can perform updates across multiple tables with a single query.