this.user Posted March 12, 2010 Share Posted March 12, 2010 select (count(table1.id) + count(table2.id)) AS counttotal FROM table3 left join table1 ON(table1.team=table3.id) LEFT JOIN table2 ON(table2.team=table3.id) WHERE table3.id = 3 when I run that query, instead of getting the result 15(10 from t1 and 5 from t2) I get 50 (which is 10 * 5), and I dont know how to fix it. Can someone please help me? Quote Link to comment https://forums.phpfreaks.com/topic/195023-left-join-issues-with-count/ Share on other sites More sharing options...
fenway Posted March 16, 2010 Share Posted March 16, 2010 And how many rows are in table3? Quote Link to comment https://forums.phpfreaks.com/topic/195023-left-join-issues-with-count/#findComment-1026904 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.