简单问题:用select得到的记录集,当做一个table,继续在sql语句里使用,应该怎么写?

[gshope]

比如:
select a,b,c from table1 where c=0
我这么写不对:
select * from (select a,b,c from table1 where c=0)

应该怎么写??不要存储过程,用一句SQL语句搞定,谢谢

[WangZWang]

select * from (select a,b,c from table1 where c=0) as tbl --要加表别名

[phantomMan]

select * from (select a,b,c from table1 where c=0)a

这样最简单了