Re: [PHP-DB] SELECT query from two tables

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.ministry_directory_entry 
> WHERE md.listing_type = 2 
> AND mdlc.ministry_directory_category_reference IN (10, 11) 
> ORDER BY ministry_directory.name ASC
> 
> 
> 
> Regards,
> 
> Bruce
> 
> >>> Ron Piggott <[email protected]> 10/03/2008 10:33:13 a.m. >>>
> I am wondering what is wrong with this syntax?  
> 
> SELECT * FROM ministry_directory INNER JOIN
> ministry_directory_listing_categories ON ministry_directory.entry =
> ministry_directory_listing_categories.ministry_directory_entry WHERE
> ministry_directory.listing_type = 2 AND
> ministry_directory_listing_categories.ministry_directory_category_reference = 10 AND ministry_directory_listing_categories.ministry_directory_category_reference = 11 ORDER BY ministry_directory.name ASC
> 
> It produces 0 results.  
> 
> In reality there is presently 1 record that should be found that has
> listing_type = 2 and ministry_directory_category_reference 10 and 11 in
> the ministry_directory_listing_categories table
> 
> The table "ministry_directory" has the main contact information.  entry
> is auto_increment; listing_type is an INT(1) column
> 
> The table ministry_directory_listing_categories has 3 columns:
> reference which is auto_increment populated;
> ministry_directory_entry which is the common field between both tables,
> showing what the record belongs to &
> ministry_directory_category_reference which is the reference number to
> how the directory listing was inputted / categorized.  (IE If the person
> who completed the form select 2 of the 10 possible categories 2 records
> were created.)  
> 
> Is there a different way to word my query so I will be able to retrieve
> the record with two rows in table ministry_directory_listing_categories
> and 1 row in ministry_directory ?
> 
> Thanks for the help guys.
> 
> Ron
> 
>