Joins can be a huge pain sometimes when you are trying to get the correct data from multiple tables

Have a read of this tutorial which should get you started - it gives a good introduction to selecting / updating data across multiple tables in MySQL.

Alan