Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Being able to bulk update multiple rows in one statement using values, similar to how you can bulk insert in one statement using values, would be great. The main motivations are performance and ...