I have a table TABLE1 where i have 2 columns ValueFrom and ValTo with SIGN option is BT. Now i need to design a View having one column which constitutes of only column.
TABLE1:
SETNAME SIGN OPTION VALFROM VALTO
ABC I BT 500700 500710
VIEW1
COLUMN1
500700
500701
500702
500703
500704
500705
500706
500707
500708
500709
500710