 select ca.propno, ca.contact0 contact   from BIUSR.tbl_trn_customer_address ca UNION select ca.propno, ca.contact0 contact   from BIUSR.tbl_trn_customer_address ca UNION select ca.propno, ca.mobile0 contact   from BIUSR.tbl_trn_customer_address ca UNION select ca.propno, ca.mobile0 contact   from BIUSR.tbl_trn_customer_address ca