I am trying to COUNT two columns in a single query, but the results are spitting out the same values for medcount and uploadcount. Any suggestions?
SELECT * , COUNT($tbl_list.listname) AS listcount,
COUNT($tbl_uploads.id) AS uploadcount
FROM $tbl_members
LEFT JOIN $tbl_list ON $tbl_members.username = $tbl_list.username
LEFT JOIN $tbl_uploads ON $tbl_members.username = $tbl_uploads.username
GROUP BY $tbl_members.username
ORDER BY $tbl_members.lastname, $tbl_members.firstname;
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…