Trouble with Joins

From: Date: Wed, 26 Feb 2003 22:20:00 +0000
Subject: Trouble with Joins
Groups: php.db 
Request: Send a blank email to php-db+get-25931@lists.php.net to get a copy of this message
I have a survey I created that when the formis being filled out it will select values from list. The list values are other tables in the same DB. When I go to get the info again I am trying to do a left join of the two table to get the description instead of the id's associated in the table. Since I used one table several time for the values how do I, can I, join that tabel multiple times on the SELECT statement so I can get each instance of the description. Ex. In the survey I reference the usercomm table 5 times to answer different questions. Since the answer for each instance could be different how do I join the usercomm table back to the replies table several times. Thanks for any help Roland Perez roland.perez@usdoj.gov

« previous php.db (#25931) next »