I have table fieldstatus where field and flag column are there.
In this table field contains the list of fields from table mstchvs.
Now here there is flag column which contains 1 or 0.
If i write select * from mstchvs
I get all the column names.
But i want to list those columns where field=0 in fieldstatus table.
select (column names from fieldstatus table where flag=0) from mstchvs