急!为啥老是报错ORA-00933 : SQL命令未正确结束。??
急!为啥老是报错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;