像这个sql 语句怎么变成临时表 ↓select * from (
SELECT a.keyword_level, a.id AS id, a.name AS name, a.url AS surl, a.keyword_type, a.end_date, a.state, a.company_name AS company, d.abouts,a.big_area_id as bigname , a.small_area_id as smallname FROM keyword a, users d WHERE ( a.state =2 OR a.state =3 ) AND a.keyword_type !=4 AND a.keyword_type !=3 AND a.keyword_type !=8 AND a.keyword_level =1 AND d.userid = a.userid ".$sql." ORDER BY a.keyword_level)Y
union all
select * from (
select a.keyword_level,a.id as id,a.name as name,a.url as surl,a.keyword_type,a.end_date,a.state,a.company_name as company,d.abouts ,b.big_name as bigname,a.small_area_id as smallname from keyword a,area_big b ,users d where (a.state=2 or a.state=3) AND a.keyword_type!=4 AND a.keyword_type!=3 AND a.keyword_type!=8 and b.id=a.big_area_id and a.keyword_level=2 and b.id=a.big_area_id and d.userid=a.userid ".$sql." order by a.keyword_level)H
union all
Select * From (
select a.keyword_level,a.id as id,a.name as name,a.url as surl,a.keyword_type,a.end_date,a.state,a.company_name as company,d.abouts ,c.big_name as bigname,b.small_name as smallname from keyword a,area_small b ,area_big c ,users as d where (a.state=2 or a.state=3) AND a.keyword_type!=4 AND a.keyword_type!=3 AND a.keyword_type!=8 and a.small_area_id = b.id and a.keyword_level=3 and d.userid=a.userid and a.big_area_id=c.id ".$sql." ORDER BY a.keyword_level desc)A我在网上搜的$db->Execute(" select * into #wordinfo from [sql 语句]"); 这样写是错的`` 请问我那个sql的表要怎么创建成临时表啊~?
SELECT a.keyword_level, a.id AS id, a.name AS name, a.url AS surl, a.keyword_type, a.end_date, a.state, a.company_name AS company, d.abouts,a.big_area_id as bigname , a.small_area_id as smallname FROM keyword a, users d WHERE ( a.state =2 OR a.state =3 ) AND a.keyword_type !=4 AND a.keyword_type !=3 AND a.keyword_type !=8 AND a.keyword_level =1 AND d.userid = a.userid ".$sql." ORDER BY a.keyword_level)Y
union all
select * from (
select a.keyword_level,a.id as id,a.name as name,a.url as surl,a.keyword_type,a.end_date,a.state,a.company_name as company,d.abouts ,b.big_name as bigname,a.small_area_id as smallname from keyword a,area_big b ,users d where (a.state=2 or a.state=3) AND a.keyword_type!=4 AND a.keyword_type!=3 AND a.keyword_type!=8 and b.id=a.big_area_id and a.keyword_level=2 and b.id=a.big_area_id and d.userid=a.userid ".$sql." order by a.keyword_level)H
union all
Select * From (
select a.keyword_level,a.id as id,a.name as name,a.url as surl,a.keyword_type,a.end_date,a.state,a.company_name as company,d.abouts ,c.big_name as bigname,b.small_name as smallname from keyword a,area_small b ,area_big c ,users as d where (a.state=2 or a.state=3) AND a.keyword_type!=4 AND a.keyword_type!=3 AND a.keyword_type!=8 and a.small_area_id = b.id and a.keyword_level=3 and d.userid=a.userid and a.big_area_id=c.id ".$sql." ORDER BY a.keyword_level desc)A我在网上搜的$db->Execute(" select * into #wordinfo from [sql 语句]"); 这样写是错的`` 请问我那个sql的表要怎么创建成临时表啊~?
[table_options] [select_statement]
我是要根据那个sql语句查出来的表 再放到一个临时表里面``
不好意思`` 新手``