I have 2 tables, enquiry and addressees.
The enquiry table references addressess by the id stored on the addressees table.
What i want to do i do a count of all enquiries, broken down into each addressee.
I've managed to get it to do it by using, "select count(enquiries.id), addressees.addressee from enquiries, addressees where enquiries.addressee_id = addressees.id group by(addressees.addressee)" this is fine except it only shows addressees who have an enquiry, i would like, in this case, there to be just a 0 value. How would i do this ??
