摘要: SELECT count(1) FROM (select t.folderservgrpid from lims_folderservgrp t--fs表里有几个科室显示几条数据 left join lims_folders t2 on t.foldersid = t2.foldersid and 阅读全文
posted @ 2020-03-25 17:55 消失的手套 阅读(190) 评论(0) 推荐(0)
摘要: select count(1) from (select l.isrepeat from lims_folders t join base_corp p on t.submitcorp = p.corpcode join lims_clearanceform l on t.clearanceid = 阅读全文
posted @ 2020-03-25 17:03 消失的手套 阅读(183) 评论(0) 推荐(0)
摘要: 正式服更新到V2020032302(流程监控增加SQL初始化) /home/app/apache-tomcat-8.5.35/logs tail -f catalina.outtail -f catalina-2020-03-23.out select b.userdesc,d.* from lim 阅读全文
posted @ 2020-03-25 11:16 消失的手套 阅读(410) 评论(0) 推荐(0)