摘要： with h_asign_id as ( select asign_id from assign_h h left join assignment a on a.id = h.asign_id where 1=1 group by h.asign_id) select h.asign_id from 阅读全文