Guest User

Untitled

a guest
Oct 21st, 2019
104
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT Kode_COA,N_Perkiraan,SUM (Debet) AS Debet,SUM (Kredit) AS Kredit FROM tbl_Jurnal WHERE
  2.  
  3. LEFT (Kode_COA,1)='4' AND (DATE) BETWEEN ? AND ? OR
  4. LEFT (Kode_COA,1)='5' AND (DATE) BETWEEN ? AND ? OR
  5. LEFT (Kode_COA,1)='6' AND (DATE) BETWEEN ? AND ? GROUP BY Kode_COA,N_Perkiraan ORDER BY 1
  6.  
  7.  
  8. -- Let's say it starts with '4' and date is within range
  9.  
  10. WHERE TRUE AND TRUE OR
  11. FALSE AND TRUE OR
  12. FALSE AND TRUE
RAW Paste Data