急问：关于Oracle中的一个查询问题！！！ - 编程论坛

#2

飙马2007-12-20 12:38

加加括号试试看看！

#3

sai_shen2007-12-20 14:04

SQL> SELECT S.ITEMCODE,B.TITLE
  2  FROM STUDENTTRANS S
  3  (INNER JOIN BOOKCATALOG B
  4  ON S.CALLNO=B.CALLNO)
  5  WHERE S.MATRICNO='MAT001';
(INNER JOIN BOOKCATALOG B
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

SQL> SELECT S.ITEMCODE,B.TITLE
  2  FROM STUDENTTRANS.S
  3  (INNER JOIN BOOKCATALOG B)
  4  ON S.CALLNO=B.CALLNO
  5  WHERE S.MATRICNO='MAT001';
(INNER JOIN BOOKCATALOG B)
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

SQL> SELECT S.ITEMCODE,B.TITLE
  2  FROM STUDENTTRANS S
  3  (INNER JOIN BOOKCATALOG B
  4  ON S.CALLNO=B.CALLNO
  5  WHERE S.MATRICNO='MAT001');
(INNER JOIN BOOKCATALOG B
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

这是我加了括号后又尝试了几次，每次都是在第3行报错，可是我关键字没有打错，表名也没有打错，这是到底是什么原因呢？
希望大家帮帮我。。。

#4

ILoveMK2007-12-20 14:28

给你参考一下
SQL> select a.empno,a.ename,a.job,b.dname
  2  from emp a inner join dept b
  3  on a.deptno=b.deptno
  4  where a.sal>2000;

     EMPNO ENAME      JOB       DNAME
---------- ---------- --------- --------------
      7782 CLARK      MANAGER   ACCOUNTING
      7698 BLAKE      MANAGER   SALES
      7566 JONES      MANAGER   RESEARCH
      7788 SCOTT      ANALYST   RESEARCH
      7902 FORD       ANALYST   RESEARCH
      7839 KING       PRESIDENT ACCOUNTING

已选择6行。