Re: SELECT query from two tables
| From: | Chris | Date: | Sun, 09 Mar 2008 23:50:35 +0000 |
| Subject: | Re: SELECT query from two tables | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44734@lists.php.net to get a copy of this message | ||
Ron Piggott wrote:
Two different rows Chris.That's the problem then. Your query is saying "get records with category_reference of 10 and it has to have category_reference of 11 as well". No such rows exist. Maybe that should be an 'or' or 'in' (same thing). ... ministry_directory_listing_categories.ministry_directory_category_reference in (10,11) ... ; so it can get both records 13 & 14.
reference ministry_directory_entry ministry_directory_category_reference 13 1 10 14 1 11-- Postgresql & php tutorials http://www.designmagick.com/