SELECT 
        cs.customer_code,
        cs.customer_name1,
        cs.customer_name2,
        cs.customer_group,
        cg.customer_name1
    FROM 
        invoice.customer cs
        LEFT OUTER JOIN invoice.customer cg ON
            cs.customer_group = cg.customer_code
    WHERE 
        cs.customer_code = '03043001'