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

The inline table issue was already clarified. Probably one of the next versions will allow the "usual" syntax. The other questions: ... WHERE UPPER(jane) = "SMITH" ORDER BY 1; You have to repeat the expression... it's probably annoying if you're not used to it, but the background job is the same. You can use numeric placeholders in ORDER BY and GROUP BY clauses. Regards internetuser wrote: > New Informix user - coming from Oracle here. I'm baffled. > > Why doesn't something simple like: > > select * from (select * from bob)> > work? > > 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). > > So far I find this flavour of SQL very limiting. Can someone help? > > Thanks! > -sw