SELECT 'GIDERLER' AS TUR2,* FROM (SELECT 'MUTFAK GIDERLER' AS TUR,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.001%')         UNION ALL      SELECT 'DİĞER GIDERLER' AS TUR,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%'))  AND (HESAP.KODU<>'770.01.001')  AND (HESAP.KODU<>'770.01.002')    AND (HESAP.KODU<>'770.01.010')        UNION ALL      SELECT 'MÜZİSYEN ve EĞLENCE GİDERLERİ' AS TUR,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.002%') OR (HESAP.KODU LIKE '770.01.010%'))        UNION ALL      SELECT 'İDARE MERKEZİ ADINA YAPILAN HARCAMALAR' AS TUR,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%')     ) AS TBL      SELECT 'GELIRLER' AS TUR2,* FROM (SELECT 'TAHSİS GELİRLERİ' AS TUR,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.001%')  OR (HESAP.KODU LIKE '136.02.002%') OR (HESAP.KODU LIKE '136.02.003%') OR (HESAP.KODU LIKE '136.02.004%') OR (HESAP.KODU LIKE '600.01.001%') )    UNION ALL      SELECT 'DİĞER GELIRLER' AS TUR,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.005%') OR (HESAP.KODU LIKE '136.02.006%') OR (HESAP.KODU BETWEEN '600.01.002' AND '600.01.016'  ))      ) AS TBL2    
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         
  ------------------ -------------------------------------- ---------------
{ [^TUR2           ] [TUR                                 ] [$BAKIYE:N    ]}[TARIH:D]
