Last time we introduced designing a MySQL database with multiple tables in mind. We discussed the basics of how to put together some SQL to JOIN our tables together in useful ways. This tutorial follows on, looking a bit closer at using the database we created in Dreamweaver.
This time we're going to look at using some JOIN queries in a web application, using Dreamweaver MX 2004 and its server behaviours. Again we'll be using our CD database as an example. We'll also look at some of the functions we can use to group rows returned by our queries together.
Author only shows how to do basic SELECT statements; maybe the title should be changed to refelect that, something like Part 2 - SELECT from Multiple tables. I was disapointed; I was looking for information on how to Update multiple tables.