急！为啥老是报错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 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也可以？？

请恕我眼拙。。。木有看出与前面语句的区别~·~

请标识一下，亮瞎我的狗眼吧！！