SELECT * FROM(  SELECT 'GIDERLER' AS TUR,HESAP.ACIKLAMA AS ACIKLAMA,SUM(HESAPISL.BORC-HESAPISL.ALACAK) AS BAKIYE   FROM HESAP,HESAPISL,FIS  WHERE HESAP.HESAPID=HESAPISL.HESAPID AND HESAPISL.FISCOUNTER=FIS.COUNTER  AND (HESAP.KODU LIKE '770.01%')   GROUP BY HESAP.ACIKLAMA  UNION ALL  SELECT 'GELIRLER' AS TUR,HESAP.ACIKLAMA AS ACIKLAMA,SUM(HESAPISL.BORC-HESAPISL.ALACAK) AS BAKIYE   FROM HESAP,HESAPISL,FIS  WHERE HESAP.HESAPID=HESAPISL.HESAPID AND HESAPISL.FISCOUNTER=FIS.COUNTER  AND ((HESAP.KODU LIKE '136.02%') OR (HESAP.KODU LIKE '600.01%'))  GROUP BY HESAP.ACIKLAMA  UNION ALL  SELECT 'IDARİ MERKEZİ ADINA YAPILAN HARCAMALAR' AS TUR,HESAP.ACIKLAMA AS ACIKLAMA,SUM(HESAPISL.BORC-HESAPISL.ALACAK) AS BAKIYE   FROM HESAP,HESAPISL,FIS  WHERE HESAP.HESAPID=HESAPISL.HESAPID AND HESAPISL.FISCOUNTER=FIS.COUNTER  AND (HESAP.KODU LIKE '770.02%')  GROUP BY HESAP.ACIKLAMA) AS TBL 

Elektra
                                                    Tarih       : [BUGUN   ]
                                                    Saat        :   [BUSAAT]
                                                    Alındığı T. : [GTARIH  ]



               İZMİR-ÖZDERE MAİM TALU EĞİTİM VE DİNLENME SİTESİ 

          --------- / ----------  TARİHLERİ ARASI KAR ZARAR CETVELİ
                               (YTL / YKR)

  TUR             ACIKLAMA                                BAKIYE        
  --------------- --------------------------------------- --------------
{ [^TUR         ] [ACIKLAMA                             ] [$BAKIYE:N   ]}[TARIH:D]
