Skip to Content
0
Jan 02, 2016 at 10:46 AM

Need Selection and Outstanding Balance in this query.

16 Views

HI everyone,

Thanks for your quick response. Actually I m unable to fetch all details while I am giving selection for T0.[GroupName] and which date need to take for outstanding balance day wise.

SELECT distinct T0.[CardCode], T0.[CardName] as 'Custmer Name', T3.[Name] as 'State',T2.[GroupName] , T0.[Balance] as 'Balance' FROM OCRD T0 left JOIN CRD1 T1 ON T0.[CardCode] = T1.[CardCode] left JOIN OCRG T2 ON T0.[GroupCode] = T2.[GroupCode] left JOIN OCST T3 ON T1.[State] = T3.[Code] and T3.Country = T1.country WHERE T0.CardType = 'C'

Thanks

Vedanth