You mean a subselect
SELECT collist FROM (
SELECT collist FROM tableX WHERE conditions
) AS subSelTable
Which this is a bad example. Please be more specific about what you are trying to do for more help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)