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? 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? 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
Archived
This topic is now archived and is closed to further replies.