SELECT d.*/*查询出download_qx d 所有字段*/,COUNT(*) COUNT,f.name/*upload_file f中原名*/ fileName/*此表新名*/,f.state fileState,f.qx fileQx
FROM download_qx d
LEFT JOIN upload_file f
ON d.fileId=f.fileId/*相同关联字段*/
WHERE 1=1
GROUP BY d.userName,f.fileId
SELECT COUNT(*) FROM (
SELECT d.*/*查询出download_qx d 所有字段*/,COUNT(*) COUNT,f.name/*upload_file f中原名*/ fileName/*此表新名*/,f.state fileState,f.qx fileQx
FROM download_qx d
LEFT JOIN upload_file f
ON d.fileId=f.fileId/*相同关联字段*/
WHERE 1=1
GROUP BY d.userName,f.fileId
) tmp
SELECT DISTINCT fileId/*字段*/ FROM download_qx/*表明*/ /*去重查询*/