Thanks
On Mon, 2008-03-10 at 12:56 +1300, Bruce Cowin wrote:
> I think what you mean to do is use IN(). And I would suggest table aliases.
> So it could look like this:
>
> SELECT * FROM ministry_directory md INNER JOIN
> ministry_directory_listing_categories mdlc ON md.entry =
> mdlc.minist
I think what you mean to do is use IN(). And I would suggest table aliases.
So it could look like this:
SELECT * FROM ministry_directory md INNER JOIN
ministry_directory_listing_categories mdlc ON md.entry =
mdlc.ministry_directory_entry
WHERE md.listing_type = 2
AND mdlc.ministry_directory_
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_listi
Two different rows Chris.
reference ministry_directory_entry ministry_directory_category_reference
13 1 10
14 1 11
What I am trying to do is allow the user to make a more specific search.
Ron
On Mon, 2008-03-10 at 10:37 +1100, Chris wrote:
>
> > ministry_directory_list
ministry_directory_listing_categories.ministry_directory_category_reference =
10 AND
>
ministry_directory_listing_categories.ministry_directory_category_reference
= 11
Can a record really have a reference for two different id's like this?
ie can it be both '10' and '11' at the same time?
