Re: Retrieve information from mutiple tables
| From: | Prodoc | Date: | Sun, 21 Apr 2002 16:53:15 +0000 |
| Subject: | Re: Retrieve information from mutiple tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18709@lists.php.net to get a copy of this message | ||
E.g. I've got two tables (User and Rights) both contianing UserID, I want to retrieve some UserID's from the Rights table and use those UserID's the get the nickname of those users from the User table.
("SELECT UserID FROM Rights WHERE...........")
("SELECT NickName FROM User WHERE...........")
Is it possible to combine those two statements?