>> I have two tables:
>> (1) members - member_id, name, phone, address
>> (2) entries - entry_id, member_id, title, description, date
>> I want to show a list of all members and, alongside each member, I want to show a
> sum of the total number of entries they have in the entries table.
>The solution of your problem is called LEFT JOIN.
>Just substitute the JOIN with a LEFT JOIN and it works:
> , m.phone
> , m.address
> , count(e.entry_id)
> members m
> LEFT JOIN entries e
> m.member_id = e.member_id
Christian, that gave me a MySQL syntax error, but I took your cue and got it working like
LEFT JOIN entries e ON m.member_id = e.member_id
Works like a charm! :-)
Thanks very much for your help.