论坛: 编程破解 标题: 查询每个季度的不合格品种 复制本贴地址    
作者: SCANDISK [scandisk]    论坛用户   登录
USE HYDEE_CS 
SELECT
        u_dist_c.rowid as 行号,
        u_dist_c.distno as 单号,
        u_ware_q.warename as 品名,
        u_ware_q.warespec as 规格,
        u_ware_q.wareunit as 单位, 
        u_dist_c.wareqty as 数量,
        u_dist_c.purprice as 单价,
        u_dist_c.purprice * u_dist_c.wareqty as 金额,
        u_dist_c.makeno as 批号, 
        u_dist_c.invalidate as 有效期, 
       
     
       
        case when isnull(u_store_i.prodid,'') = '' then u_ware_q.producer else u_producer.producer end as 生产厂家,
       
u_dist_c.notes as 备注,
case when (u_store_i.prod_addid is not null and u_store_i.prod_addid <> '') then (select u_prod_add.prod_add from u_prod_add where u_prod_add.prod_addid = u_store_i.prod_addid) else u_ware_q.prod_add end as 产地
    FROM u_dist_m,u_dist_c  ,u_ware_q,u_ware_ext,u_store_i left join u_producer on u_store_i.prodid = u_producer.prodid
left join u_vendor on u_vendor.vendorno = u_store_i.vendorno
    where u_dist_c.wareid = u_ware_q.wareid and u_dist_c.wareid = u_store_i.wareid  and u_dist_c.batchno = u_store_i.batchno
and u_dist_c.idno = u_store_i.idno and u_ware_q.wareid = u_ware_ext.wareid and u_dist_c.distno=u_dist_m.distno and u_dist_m.billcode='FAL'
          and u_dist_m.paydate>='2021-04-01 00:00:00' AND u_dist_m.paydate<'2021-07-01 00:00:00' and u_dist_c.notes<>'到有效期' ORDER BY U_DIST_C.DISTNO, ROWID

地主 发表时间: 21-10-15 02:30

论坛: 编程破解

20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写：NetDemon

粤ICP备05087286号