先limit再join SELECT a.prj_id,a.pre_doc_id,a.out_time, a.inactive_user, a.inactive_time, u.use_nm, GROUP_CONCAT(Distinct d.job_no) jb_nos,ifnull(sum(b.qty),0) pre_qty, ifnull(sum(c.qty),0) qty, ……
