I am currently filtering a table from a database using the SELECT FROM sql command. Does anyone know how I can then filter the results from the first query to produce another set of results?

Can this be done with the SELECT INTO command and if so how do you use this command?

Thanks
Tom