为什么这个句子运行时提示AS附近出错呢?麻烦大家看看
CREATE TABLE AAA(MSISDN CHAR,OPTIME CHAR,SPID CHAR,SPNAME CHAR,SERVICENAME CHAR)AS(select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME FROM [USER.200906.591] U,SERVICE20090630591 S WHERE U.spid=S.spid AND S.servicetype in('2','3'))
CREATE TABLE AAA(MSISDN CHAR,OPTIME CHAR,SPID CHAR,SPNAME CHAR,SERVICENAME CHAR)AS(select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME FROM [USER.200906.591] U,SERVICE20090630591 S WHERE U.spid=S.spid AND S.servicetype in('2','3'))
(select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME FROM [USER.200906.591] U,SERVICE20090630591 S WHERE U.spid=S.spid AND S.servicetype in('2','3'))
drop table aaa
go
insert into AAA
select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME
FROM [USER.200906.591] U,SERVICE20090630591 S
WHERE U.spid=S.spid AND S.servicetype in('2','3')
CREATE TABLE AAA
(MSISDN CHAR,OPTIME CHAR,SPID CHAR,SPNAME CHAR,SERVICENAME CHAR)insert into AAA
select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME
FROM [USER.200906.591] U,SERVICE20090630591 S
WHERE U.spid=S.spid AND S.servicetype in('2','3')
CREATE TABLE AAA(MSISDN CHAR,OPTIME CHAR,SPID CHAR,SPNAME CHAR,SERVICENAME CHAR)
go
insert into AAA
select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME
FROM [USER.200906.591] U,SERVICE20090630591 S
WHERE U.spid=S.spid AND S.servicetype in('2','3')
CREATE TABLE AAA(MSISDN CHAR,OPTIME CHAR,SPID CHAR,SPNAME CHAR,SERVICENAME CHAR)
go
insert into AAA
select DISTINCT U.msisdn,U.OPTIME,U.SPID,U.SPNAME,U.SERVICENAME
FROM [USER.200906.591] U,SERVICE20090630591 S
WHERE U.spid=S.spid AND S.servicetype in('2','3')
FROM [USER.200906.591] U,SERVICE20090630591 S
WHERE U.spid=S.spid AND S.servicetype in('2','3')这样就好了,不需要手工创建表