Question

SQL未找到要求的 FROM 关键字?

select * , row_number() over (order by CJRQ DESC) FLUENTDATA_ROWNUMBER from
(select * from YX_YQ_FJXX UNION select * from YX_OA_FJXX);

Answer 1

oracle里要这么用才对，你这个类似于sqlserver的写法insert into abcd
select '10','Administration','1700','1' from dual
union allselect '20','Marketing','1800','2' from dual
union allselect '50','Shipping','1500','5' from dual
union allselect '60','IT','1400','3' from dual
union allselect '80','Sales','2500','3' from dual
union allselect '90','Executive','1700','3' from dual
union allselect '110','Accounting','1700','2' from dual
union allselect '190','Contracting','1700','0' from dual;

Answer 2

你这语句本来就写的有问题，你的查询要求是什么说一下啊。

追问

查询两个表的数据显示在grid上