SQL语法或数据库限制? [英] SQL syntax or database constrictions?

问题描述

我有2个表，每个表都有一个列MNR.我想与他们一起参加本专栏.

I have 2 tables that have each a column MNR. I want to join them with this column.

以下两个SQL语句失败.最后一个显示我的日期格式正在运行(会话格式已更改). DB是Oracle.

The following two SQL statements fail. The last one shows that my date format is working (with changed session format). DB is Oracle.

有人可以告诉我我做错了什么吗?，我怎么称呼此联接?

Can someone please tell me what I'm doing wrong ? And what do I call this join ?

// fails
select a.CREATEDATE, a.BELEGNRRECH, a.MNR, a.UTNR, a.KTXT, b.ANR
from INFOR.RELFBR as a, INFOR.RELXDB as b
where (a.SAINT = '90') and (a.MNR = b.MNR) and (b.SAINT = '10')
     and (a.CREATEDATE >= '01.01.2014 00:00:00')
order by a.CREATEDATE

// fails as well
select a.CREATEDATE, a.BELEGNRRECH, a.MNR, a.UTNR, a.KTXT, b.ANR
from INFOR.RELFBR as a, INFOR.RELXDB as b
where (a.SAINT = '90') and (a.MNR = b.MNR) and (b.SAINT = '10')
order by a.CREATEDATE

// all fine
select CREATEDATE, MNR
from INFOR.RELFBR
where (CREATEDATE >= '01.01.2014 00:00:00')
order by CREATEDATE

失败错误为ORA-00933: SQL command not properly ended
删除"...排序"后，会发生相同的错误.

Failing error is ORA-00933: SQL command not properly ended
After removing "order by ..." same error occurs.

推荐答案

将AS排除在表别名之外-AS可以与选择列表一起使用，但不能在FROM子句中使用

Exclude AS from table aliasing - AS can be used with selection list but not in FROM clause

select a.CREATEDATE, a.BELEGNRRECH, a.MNR, a.UTNR, a.KTXT, b.ANR
from INFOR.RELFBR a, INFOR.RELXDB b
where (a.SAINT = '90') and (a.MNR = b.MNR) and (b.SAINT = '10')
     and (a.CREATEDATE >= '01.01.2014 00:00:00')
order by a.CREATEDATE

示例:

SQL> select * from t_dummy t;

                      X                                                         
-----------------------                                                         
                 9.0000                                                         

SQL> select * from t_dummy as t;
select * from t_dummy as t
                      *
error in line 1:
ORA-00933: SQL command not properly ended

文档:

http://docs.oracle.com/cd/B19306_01/server .102/b14200/statements_10002.htm#i2126863

这篇关于SQL语法或数据库限制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！