 SELECT H.KODU AS HKODU, H.KEBIR AS KEBIRKODU, H.KEBIR &' : '& H2.ACIKLAMA AS K, FIS.TARIH AS TARIH, FIS.FISNO, FIS.YEVNO AS YEVNO, HI.ACIKLAMA, HI.BORC, HI.ALACAK, HI.DBORC, HI.DALACAK, HI.MBORC, HI.MALACAK, H.DOVTURU FROM HESAP AS H, FIS, HESAPISL AS HI, HESAP AS H2 WHERE FIS.COUNTER=HI.FISCOUNTER AND H.HESAPID=HI.HESAPID AND  H.KODU >= '100.01.001' AND H.KODU <= '100.01.001' AND H.KEBIR=H2.KODU AND FIS.TARIH >= DATEVALUE('01.01.2004') AND FIS.TARIH <= DATEVALUE('31.12.2004') UNION ALL SELECT H.KODU AS HKODU, H.KEBIR AS KEBIRKODU, H.KEBIR &' : '& H2.ACIKLAMA AS K,DATEVALUE('31.12.2003'), '','','DEVİR TOPLAMLARI', SUM(HI.BORC), SUM(HI.ALACAK), SUM(HI.DBORC), SUM(HI.DALACAK), SUM(HI.MBORC), SUM(HI.MALACAK), H.DOVTURU FROM HESAP AS H, FIS, HESAPISL AS HI, HESAP AS H2 WHERE FIS.COUNTER=HI.FISCOUNTER AND H.HESAPID=HI.HESAPID AND  H.KODU >= '100.01.001' AND H.KODU <= '100.01.001' AND H.KEBIR=H2.KODU AND FIS.TARIH  < DATEVALUE('01.01.2004') GROUP BY H.KODU,H.KEBIR,H2.ACIKLAMA,H.DOVTURU ORDER BY KEBIRKODU,YEVNO,TARIH
 [Elektra                                                                                               ]

                                         DEFTER-İ KEBİR  

 KOD  TARIH      HESAP KODU           YEVM.NO  BORC              ALACAK            BAKİYE
 ---- ---------- -------------------- -------- ----------------- ----------------- -----------------------
{[^K] [TARIH:D ] [HKODU             ] [YEVNO ] [+BORC          ] [+ALACAK        ] [+&&05-06 BA          ]}
