You can use eview out of the files section to do that.
You also can do it with coding.
look at create sql view as select ...... in the help
Chapter 8 of the programmers guide is very helpfull too. Halfway there is a sample of how to do this.