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]
