新增文章

文章标题分类内容

where  having
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 应收收款核销记录

select  
   
       a1.FSrcDate,a1.FSourceFromId,a1.FSrcBillId,a1.FSrcBillNo

,a2.FSrcDate        FTargetDate
      ,a2.FSourceFromId   FTargetFromId
      ,a2.FSrcBillId      FTargetBillId
      ,a2.FSrcBillNo      FTargetBillNo
      ,ot12.FName         FTargetBillName

,sum(a1.FCurWrittenOffAmountFor)  FAmountRec

,count(1)  FRow
      
   from t_Ar_RecMacthLogEntry  a1
   join t_Ar_RecMacthLogEntry  a2  on  a2.FID = a1.FID and a2.FSourceFromId = a1.FTargetFromId and a2.FSrcBillId = a1.FTargetBillId and a2.FSrcRowId = a1.FTargetEntryId
   
   left join  t_Meta_ObjectType_L   ot12  on ot12.FID = a2.FSourceFromId and ot12.FLocaleId = 2052   -- 单据对象.名称

where a1.FSourceFromId = 'AR_Receivable' -- and a1.FID in ( 102986,102987,102988,102989)

group by 
   
       a1.FSrcDate,a1.FSourceFromId,a1.FSrcBillId,a1.FSrcBillNo
      ,a2.FSrcDate,a2.FSourceFromId,a2.FSrcBillId,a2.FSrcBillNo ,ot12.FName

having count(1) > 1