[PHP-DB] selecting from multiple tables on one database

[Todd Pillars]

I have checked the mysql.com docs and phpbuilder.com and zend.com and I am
more confused than ever on selecting a single common record from multiple
tables. Here is what I have so far.

MySQL 3.23.22
PHP 4.0.3pl1
RedHat 6.1

members

        table1
                ID              # auto_increment
                UserName        # unique
                Name
                Address
                City
                State
                ZIP

        table2
                ID              # auto_increment independent of table1
                UserName        # unique
                Birthday
                Sex
                Age

        table3
                ID              # auto_increment independent of table1 and table2
                UserName
                SpouseName
                SpouseBirthay
                SpouseAge
                DateTime        # last update

I am trying to pull out UserName, City, State from table1 - Sex, Age from
table2 - and Age from table3 where the ID number of table1 is '1'; Meaning I
only want one row containing the common information.

If I use the following select statement I get 12 rows of data that do not
contain what I am looking for!

SELECT table1.UserName, table1.City, table1.State, table2.Sex, table2.Age,
table3.SpouseAge FROM table1, table2, table3 WHERE table1.ID = '1'

Can someone help please, or at least send me in the right direction?

t.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]