SELECT $last_name, $first_name, $order_number
    FROM   $customers
    LEFT OUTER JOIN $orders ON $customer_id = $o_customer_id