oracle中as的用法？

[yuanhao0407]

SELECT t1.CON_ID,t1.CON_TYPE,t1.CON_NUMBER,t1.CON_NAME,t1.CON_DATE, t2.CUS_NAME as CON_CUSTOMER,t1.CON_REMARKS,
t1.CON_FILES,t1.CON_STATUS from CON_CONTRACT as t1 left join CUS_CUSTOMER as t2 on t1.CON_CUSTOMER=t2.CUS_ID where 1=1

为什么 from CON_CONTRACT as t1 left join CUS_CUSTOMER as t2 这两个as会报错

[yuanhao0407]

[SQL]select t1.CON_ID,t1.CON_TYPE,t1.CON_NUMBER,t1.CON_NAME,t1.CON_DATE, t2.CUS_NAME as CON_CUSTOMER,t1.CON_REMARKS,t1.CON_FILES,t1.CON_STATUS from CON_CONTRACT as t1 left join CUS_CUSTOMER as t2 on t1.CON_CUSTOMER=t2.CUS_ID where 1 = 1 [Err] ORA-00933: SQL 命令未正确结束

[卖水果的net]

把 AS 去掉， 表别名不能写 AS ，列可以写

[baofeidyz]

表别名不加as，实际上在列别名一般也不加as，空格间隔即可。

[yuanhao0407]

引用 2 楼 wmxcn2000 的回复:

把 AS 去掉， 表别名不能写 AS ，列可以写

哦，oracle怎么还有这个要求，以前用SQLserver可以这样写

[卖水果的net]

引用 4 楼 github_36859217 的回复:

[quote=引用 2 楼 wmxcn2000 的回复:] 把 AS 去掉， 表别名不能写 AS ，列可以写

哦，oracle怎么还有这个要求，以前用SQLserver可以这样写[/quote] 嗯， SQLServer 是可以这样写的，Oracle 不行，这个应该就是大家常说的 “规定” 吧