informix建表

[clon_forever]

create table rm_trans_circuit_route as
(select CR.ZENDMEOBJECTID,CR.ZENDMEOBJECTID, CR.AENDPTPOBJECTID,CR.AENDPTPOBJECTID
from CIRCUITROUTE CR JOIN CIRCUIT C ON C.OBJECTID=CR.CIRCUITOBJECTID
WHERE C.SERVICETYPE IN(***) AND C.CIRCUITSTATE NOT IN(***') and CR.OBJECTID is not null);


报错 error code -201

哪里有问题，请高手指导，详细更好哈，本人没用过这个数据库

[阳泉酒家小当家]

这个 单引号 是什么意思： create table rm_trans_circuit_route as (select CR.ZENDMEOBJECTID,CR.ZENDMEOBJECTID, CR.AENDPTPOBJECTID,CR.AENDPTPOBJECTID from CIRCUITROUTE CR JOIN CIRCUIT C ON C.OBJECTID=CR.CIRCUITOBJECTID WHERE C.SERVICETYPE IN(***) AND C.CIRCUITSTATE NOT IN(***') and CR.OBJECTID is not null);

[clon_forever]

引用 1 楼 yupeigu 的回复:

这个 单引号 是什么意思： create table rm_trans_circuit_route as (select CR.ZENDMEOBJECTID,CR.ZENDMEOBJECTID, CR.AENDPTPOBJECTID,CR.AENDPTPOBJECTID from CIRCUITROUTE CR JOIN CIRCUIT C ON C.OBJECTID=CR.CIRCUITOBJECTID WHERE C.SERVICETYPE IN(***) AND C.CIRCUITSTATE NOT IN(***') and CR.OBJECTID is not null);

那个没事，我只是想说明括号里有内容， Informix 有这种建表语句吗 create table A as select * from b where ***

[阳泉酒家小当家]

你这种创建表的方法是oracle的，应该不适合infomix