keevitaja Posted November 2, 2011 Share Posted November 2, 2011 there are 3 tables campaigns id int cp_contacts id int campaign_id int cp_friends id int cp_contact_id i need to retrieve all rows from campaigns and add how many contacts campaigns has total and how many friends total connected to campaigns thrugh contacts . i can get out the cp_contacts count with left join. can anyone help me? Quote Link to comment Share on other sites More sharing options...
Wiro Blangkon Posted November 2, 2011 Share Posted November 2, 2011 Hello Keevitaja, Can you (1) show us the join you use and (2) tell us in simple, non-MySQL, English what information you want to retrieve from the database? Wiro Blangkon. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.