I grown my db to 4 tables 8). I'm going to ask this plainly in hopes that my "syntax" in ok:
I know how to SELECT * from 2 related tables and get all the records listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been looking some books!
How do get a resultset of all records from 4 related tables?
Same idea, but you use a 4-way join rather than a 2-way join.
Ted
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
