X5 自己系统用到的sql 语句

最新推荐文章于 2024-09-12 01:21:29 发布

ooopopdj

最新推荐文章于 2024-09-12 01:21:29 发布

阅读量365

点赞数

本文链接：https://blog.csdn.net/ooopopdj/article/details/42023561

版权

1 已车间分组
select b.fbbygxm,sum(b.fbbdrgs), b.fbbygh ,t.fcjmiaoshu from yt_lhgs_lr t ,yt_lhgs_bbtj b where t.fwgzt= '已完工' and t.fid =b.fbbid group

by b.fbbygxm ,b.fbbygh,t.fcjmiaoshu

EXECL 格式插入数据语句

insert into yt_cxda_sjwh bb
(bb.fid, bb.ffl, bb.fcnrq,bb.fqy)
select sys_guid(), '财务类', to_date('2014-12-12','yyyy-mm-dd'),sa_oporg.sfname
    from sa_oporg
   where sa_oporg.scode =
         (select t.scode from sa_opperson t where sloginname = '90002394');

去除空格

insert into yt_cxda_sjwh bb
(bb.fid, bb.ffl, bb.fcnrq,bb.fqy)
select sys_guid(), '财务类', to_date('2014-12-12','yyyy-mm-dd'),sa_oporg.sfname
    from sa_oporg
   where sa_oporg.scode =
         (select t.scode from sa_opperson t where sloginname = trim(' 90002394 '));