Need help converting ACL Scripts into SQL
//-------
OPEN DDMAST
CLASSIFY ON Branch SUBTOTAL CurrentBalance IF Status <> '2' & CurrentBalance >= 0 TO DDMAST_Dep Open
Sort on Branch TO DDMASTDepBase
comment EXPORT FIELDS Branch COUNT CurrentBalance EXCEL TO "DDDep_2017"
OPEN DDMAST
CLASSIFY ON Branch SUBTOTAL CurrentBalance IF Status <> '2' & CurrentBalance < 0 TO DDMAST_Dep2
Open DDmastDepBase
Open DDMAST_Dep2 SECONDARY
JOIN MANY PKEY Branch FIELDS Branch COUNT CurrentBalance SKEY Branch WITH Branch COUNT CurrentBalance IF CurrentBalance <> 0 TO DDMASTDepBase2
JOIN UNMATCH PKEY Branch FIELDS Branch COUNT CurrentBalance SKEY Branch WITH Branch COUNT CurrentBalance TO DDMAST_Dep3 OPEN
Branch1 = ' '
COUNT1 = 0
CurrentBalance1 = 0.00
GROUP IF CurrentBalance <> 0
Branch1 = ' '
COUNT1 = 0
CurrentBalance1 = 0.00
EXTRACT Branch COUNT CurrentBalance Branch1 Count1 CurrentBalance1 TO DDMASTDepBase4
END
OPEN DDMASTDepBase2
OPEN DDMASTDepBase4 Secondary
Merge PKEY Branch SKEY Branch1 TO DDMASTDepBase5 OPEN
T_COUNT = 0
T_CurrentBalance = 0.00
GROUP IF Branch <> ''
TotalCOUNT = COUNT + COUNT2
TotalBalance = CurrentBalance + CurrentBalance2
EXTRACT Branch COUNT CurrentBalance Branch2 COUNT2 CurrentBalance2 TotalCOUNT TotalBalance TO DDMASTDepBase6
END
--//
