sql1 = "select convert(char(10),max(tarih),104) as alacakmaxtarih,borcmu,carikod,bag into T1 
  from chareket 
  where borcmu='A' 
  group by carikod,borcmu,bag" 
   
  sql2 = "select convert(char(10),max(tarih),104) as borcmaxtarih,borcmu,carikod,bag into T2 
  from chareket 
  where borcmu='B' 
  group by carikod,borcmu,bag" 
   
  sql3 = "SELECT dbo.cari.ckodu, dbo.cari.cunvan, dbo.carihesap.talacak, dbo.carihesap.tborc, dbo.cari.ccinsi, dbo.cari.krbag, 
              case when dbo.carihesap.tborc - dbo.carihesap.talacak >'0' then dbo.carihesap.tborc - dbo.carihesap.talacak end as borcbakiye, 
              case when dbo.carihesap.tborc - dbo.carihesap.talacak <'0' then ABS(dbo.carihesap.tborc - dbo.carihesap.talacak) end as alacakbakiye,  
              dbo.T1.bag,T1.alacakmaxtarih,T1.borcmu,T2.borcmaxtarih,T2.borcmu 
  FROM dbo.cari INNER JOIN dbo.carihesap ON dbo.cari.csira = dbo.carihesap.crbag  
                        FULL OUTER JOIN T1 on dbo.cari.csira=dbo.T1.bag 
                        FULL OUTER JOIN T2 on dbo.cari.csira=dbo.T2.bag 
  WHERE ckodu between '" & cari_bas_kodu & "' and '" & cari_bit_kodu & "'" 
   
  sql4 = "drop table T1" 
   
  sql5 = "drop table T2"