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

as a side note, you don't have to include lwind_name twice in the select clause. select lwind_name winName from land_window where lower(lwind_name) = 'coastal plain' internetuser wrote: > OK, so I have to do something like this: > > select lwind_name, lower(lwind_name) winName > from land_window where lower(lwind_name) = 'coastal plain'