Sql 将多个表查询的结果进行再次查询

把你目前查到结果集定义为一个临时表 tempTable
下面是如何查  SELECT *   FROM   tempTable  where  关键字=‘’举例

select book_num,book_name,book_type from
(select * from bookinfo ) as temptable  where book_num=2