select
    t2.*
from
    deliver_record as t1
    join job_info as t2 on t1.job_id = t2.job_id
-- where t1.resume_if_checked = 1
-- order by
--    t2.company_id;