急！为啥老是报错ORA-00933 : SQL命令未正确结束。？？
请高手指点指点。。谢谢了~

代码如下：

select a.date,
       a.id,
       b.name,
       b.spec,
       b.units,
       b.quantity,
    from 表1 as a
    full outer join 表2 as b
    on a.date = b.date
       and a.no = b.no
       and b.name = 'AA'
    order by a.date,a.no;

这命令哪抄来的？

斑竹大人，这真心是自己写的，不是抄的。。。。

你写成一行再把后面的分号去掉看看

改成这样再试试：
select a.date,a.id,b.name,b.spec,b.units,b.quantity from 表1 as a,表2 as b where 条件 order by a.date

条件一个一个地加，更容易分清是哪个条件不正确。

是这样么？。。。还是报同样的错诶~·~
select a.date,a.id,b.name,b.spec,b.units,b.quantity from 表1 as a full outer join 表2 as b on a.date = b.date and a.no = b.no and b.name = 'AA' order by a.date,a.no

是这样么？。。。还是报同样的错诶~·~
select a.date,a.id,b.name,b.spec,b.units,b.quantity from 表1 as a full outer join 表2 as b on a.date = b.date and a.no = b.no and b.name = 'AA' order by a.date,a.no

分号是一定要的吧...我是想在PL/SQL里面做个对两个表的连件查询。

我想对2个表连接查询，不用full outer join也可以？？

select a.date,a.id,b.name,b.spec,b.units,b.quantity from 表1 as a full outer join 表2 as b on a.date = b.date and a.no = b.no and b.name = 'AA' order by a.date,a.no

and b.name = 'AA'
and ALLTRIM(b.name) = 'AA'
最好是帖出两个表的结构及数据

[ 本帖最后由 bccn201203 于 2012-8-4 13:09 编辑 ]