Great explanation of table JOINS on the following picture:
http://i.stack.imgur.com/N1IGZ.jpg
Totally simple multiple UPDATE statement:
Optimize SQL DB:
http://blog.intellisenseipt.com/sql-tips-to-speed-up-your-database/
Great explanation of table JOINS on the following picture:
http://i.stack.imgur.com/N1IGZ.jpg
Totally simple multiple UPDATE statement:
Optimize SQL DB:
http://blog.intellisenseipt.com/sql-tips-to-speed-up-your-database/