Unknown table 'category_table' in field list

[figment]

Here is my select:

SELECT entry_table.*, count(response_table.r_id) as r_count, category_table.c_name 
FROM entry_table 
JOIN category_table 
ON  (category_table.c_id = entry_table.c_id ) 
LEFT JOIN response_table 
ON entry_table.e_id=response_table.e_id 
GROUP BY entry_table.e_id 
ORDER BY entry_table.e_timestamp DESC 

The goal is to select from three tables:
i want all columns from entery_table.

I want only the category name ('c_name') from the category, but it must be specific to the entry assocciated with that record, however, there CAN be entries with no matching c_id (i.e. - no category), and i want those too, those are the ones falling off the query/not geting returned...

And then, count of response records that also have that entry ID (e_id) assocciated with that record.

ive never been good with sql... HELP! :-D thanks

[eoghain]

SELECT entry_table.*,
       count(response_table.r_id) as r_count,
       category_table.c_name 
  FROM entry_table 
  LEFT OUTER JOIN category_table 
    ON  (category_table.c_id = entry_table.c_id )
  LEFT JOIN response_table 
    ON entry_table.e_id=response_table.e_id 
 GROUP BY entry_table.e_id 
 ORDER BY entry_table.e_timestamp DESC 

To get all entries from 1 table weather or not entries exist in a second table you need to use an outer join. In this case it's a LEFT OUTER JOIN. So all rows from entry_table will be returned, and any matching rows found in category_table will fill in the c_name field, if there isn't a matching row then the field will be left blank.