SELECT lastName, location, model, make
FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID
...common?
I guess that's actually called a multiple select statement, not a multiple Join. (?) You wouldn't use those terms interchangeably would you?
Thanks, Ted
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]