Re: get field name

Chenri wrote: how do i get field name from this table Time Stat1 Stat2 Stat3 0905 1 1 1 0906 1 0 1 i want to get the field name Stat1 & Stat 3 from the 0906 row which have 1 as value I expect the result to be STAT1 STAT3 This is not easily done, if I understand

get field name

how do i get field name from this table Time Stat1 Stat2 Stat3 0905 1 1 1 0906 1 0 1 i want to get the field name Stat1 & Stat 3 from the 0906 row which have 1 as value I expect the result to be STAT1 STAT3 Select xxx from table_time where xxx=1 and Time=