select id,name,value1 as value from tableunion allselect id,name,value2 as value from table
select id,name,value1 from tableunion allselect id,name,value2 from table
