Home Explore Help
Register Sign In
milislinux
/
giom
Watch 1
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
giom
/
altyapi
/
rapor
/
giren_ve_iade_faturalar.sql

giren_ve_iade_faturalar.sql 752 B
Permalink History Raw

123 
  1. SELECT * FROM `fatura` WHERE KAYNAK='28' AND HEDEF='03' AND (FTIP='C' OR (FNO LIKE 'I%' AND FTIP='G')) AND TARIH BETWEEN '2015-03-01' AND '2015-03-31' ORDER BY FTIPSELECT tarih,fno,aciklama,case when ftip='C' then geneltoplam else 0 end as giris,
    2. 

  2. case when ftip='G' then geneltoplam else 0 end as cikis FROM `fatura` WHERE KAYNAK='28' AND HEDEF='03' AND (FTIP='C' OR (FNO LIKE 'I%' AND FTIP='G')) AND TARIH BETWEEN '2015-03-01' AND '2015-03-31' ORDER BY FTIPSELECT tarih,fno,aciklama,case when ftip='C' then geneltoplam else 0 end as giris,
    3. 

  3. case when ftip='G' then geneltoplam else 0 end as cikis FROM `fatura` WHERE KAYNAK='28' AND HEDEF='03' AND (FTIP='C' OR (FNO LIKE 'I%' AND FTIP='G')) AND TARIH BETWEEN '2015-03-01' AND '2015-03-31' ORDER BY FTIP
    4.