select a.*,
        c.addtime as md_zjjftime,
        d.addtime as md_dyckaitong,
        c.validity as md_vipendtime,
        c.paytype as md_paytype
from zu_job_company a
left join 
(
    select comid,MAX(intid) as maxid,MIN(intid) as minid from zu_job_money_detail
    where flag=1
    group by comid
) b  on a.id=b.comid
left join zu_job_money_detail c on b.maxid = c.id 
left join zu_job_money_detail d on b.minid = d.id

------解决方案--------------------
探讨


SQL code

select a.*,
        c.addtime as md_zjjftime,
        d.addtime as md_dyckaitong,
        c.validity as md_vipendtime,
        c.paytype as md_paytype
from zu_job_company a
left join 
(
  ……