查找上一季度的数据

最新推荐文章于 2024-09-30 09:39:55 发布

Account007

最新推荐文章于 2024-09-30 09:39:55 发布

阅读量697

点赞数

CC 4.0 BY-SA版权

文章标签： join

本文链接：https://blog.youkuaiyun.com/Account007/article/details/2307556

IF (MONTH('2008-08-01')-3>=1)
select t2.whsname as 'whsname',t3.code as 'code',t3.name as 'name',
    sum(t0.linetotal)as 'linetotal' from inv1 t0
    inner join OOBR t1 on t1.itemcode=t0.itemcode
    left join OBUI t6 on t0.docentry=t6.docentry
    left join OHID t2 on t2.whscode=t0.whscode
    left join [@CATEGORYTABLE] t3 on t3.code=t1.U_CategoryCode
WHERE (CASE WHEN MONTH(t6.date) IN (1,2,3) THEN '1'
            WHEN MONTH(t6.date) IN (4,5,6) THEN '2'
            WHEN MONTH(t6.date) IN (7,8,9) THEN '3'
            WHEN MONTH(t6.date) IN (10,11,12) THEN '4'END)=
            (CASE WHEN MONTH('2008-08-01') IN (1,2,3) THEN '4'
            WHEN MONTH('2008-08-01') IN (4,5,6) THEN '1'
            WHEN MONTH('2008-08-01') IN (7,8,9) THEN '2'
            WHEN MONTH('2008-08-01') IN (10,11,12) THEN '3' END)
            AND YEAR(t6.date)=YEAR('2008-08-01')
group by t2.whsname,t3.code,t3.name,t0.whscode
ELSE
select t2.whsname as 'whsname',t3.code as 'code',t3.name as 'name',
    sum(t0.linetotal)as 'linetotal' from inv1 t0
    inner join OOBR t1 on t1.itemcode=t0.itemcode
    left join OBUI t6 on t0.docentry=t6.docentry
    left join OHID t2 on t2.whscode=t0.whscode
    left join [@CATEGORYTABLE] t3 on t3.code=t1.U_CategoryCode
where YEAR(t6.date)=YEAR(t6.date)-1 AND MONTH(t6.date) IN (10,11,12)
group by t2.whsname,t3.code,t3.name,t0.whscode