SELECT po.id, po.po_number, s.company_name as supplier_name, po.order_date, po.expected_delivery_date,
   po.total_amount, po.status, po.created_at
   FROM purchase_orders po
   LEFT JOIN suppliers s ON po.supplier_id = s.id