select t1.colname ,t1.colname2 -- etc -- from dbo.table as t1 where -- snip conditions --