select dp.status
FROM ins_delivery_package dp left join ins_delivery de on dp.delivery_order=de.delivery_order
WHERE dp.orderid = #{orderNo}