SELECT 
            m.apply_date,
            m.merge_group_code,
            c.customer_name1 
        FROM
            invoice.merge_group m
            LEFT OUTER JOIN invoice.customer c ON
                m.merge_group_code = c.customer_code
        WHERE
            m.customer_code = '03043001'
        ORDER BY
            m.apply_date