Re: select * from (select * from bob) and other easy stuff

> Why doesn't something simple like: > select * from (select * from bob)> work? SELECT * FROM TABLE(MULTISET(SELECT * FROM bob)) > Also, if you do something like : > select upper(bob) jane from sometable > where jane = 'SMITH' > order by jane > it doesn't work either. It lets jane appear in the order by, but not > the where clause. > So how are you supposed to limit your results based off of aliased > (virtual) columns? This comes up for pretty much any time you use a > function against a column to get some result ("decode" is what I am > working with at the moment).