Merging sql fields to create an 008

008-control_field-merge

SELECT 
--
c.p00||c.p01||c.p02||c.p03||c.p04||c.p05||c.p06||c.p07||c.p08||c.p09||c.p10||c.p11||c.p12||c.p13||c.p14||c.p15||c.p16||c.p17||c.p18||c.p19||c.p20||c.p21||c.p22||c.p23||c.p24||c.p25||c.p26||c.p27||c.p28||c.p29||c.p30||c.p31||c.p32||c.p33||c.p34||c.p35||c.p36||c.p37||c.p38||c.p39||c.p40||c.p41||c.p42||c.p43
--merging control_field table into an 008 field
FROM 
sierra_view.control_field AS c
limit 100;