如果要去重,统计数量,就用DISTINCT
SELECT count(DISTINCT s.id) from t_ss s LEFT JOIN t_kk k on s.id=k.sid
参考:https://www.pianshen.com/article/67551321835/
如果要去重,统计数量,就用DISTINCT
SELECT count(DISTINCT s.id) from t_ss s LEFT JOIN t_kk k on s.id=k.sid
参考:https://www.pianshen.com/article/67551321835/