selecting question
| From: | ACEAlex | Date: | Wed, 20 Feb 2002 13:03:15 +0000 |
| Subject: | selecting question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17084@lists.php.net to get a copy of this message | ||
Hi i have trouble with this mysql query.
OK, i have 3 different tables.
Tabel 1: building_info
id
name
price
and other
table 2:queue
id
building_id
table 3:buildings_built
building_id
Ok, now i want to make a query that gets the data from building_info where
it is not pressent in the queue and the buildings_built table.
I have managed to get this to work with only 2 tables. So that i can get the
things that are not present in the building_queue or in the buildings_built
Anyony have a nice solution for this?
/Alexander