Selecting columns from a sub-query

Hi,

I am trying to do something like this:


Selecting columns from a sub-query.
For e.g:
SELECT col1,col3 FROM
(SELECT col1, col2, col3, col4, col5)

I am not able to do this.

This is done using following:
Query type: "Enter the SQL Code"

Do share your thoughts.

Thanks,
Nirav.

Hello

try this

SELECT tmp.col1,tmp.col3 FROM
(SELECT col1, col2, col3, col4, col5 From myTable ) as tmp

Regards