I have 3 tables in my database.

• ab_contacts
  • id
  • first_name
  • last_name
  • addressbook_id
• ab_addressbooks
  • name
  • id
• co_comments
  • id
  • link_id
  • comment

I'd like to create a query that will let me select all the contacts and comments related to them in a given addressbook.

To select all the people in a given addressbook, I can use:

select count(*) from ab_contacts where addressbook_id = '50';

This returns 8152 people.

However, when I run my query:

select ab_contacts.first_name, ab_contacts.last_name, ab_contacts.email,   
    ab_addressbooks.name, co_comments.comments 
from ab_contacts 
JOIN ab_addressbooks ON (ab_contacts.addressbook_id = ab_addressbooks.id) 
JOIN co_comments ON (ab_contacts.id = co_comments.link_id) 
WHERE ab_contacts.addressbook_id = '50';`

the format works, but I only get 1045 results. I'm sure there is something I am missing, but I cannot figure it out. Any help would be greatly appreciated.