구전산_카드현금체크해서 구해오기
// 카드 현금 체크해서 구해오기 Program : OpdMain From : FrmNu_Slip Function : Read_Slip_View1() 수정 Query SELECT B_DATE, SUM(Decode(O.S_Bun,94,O.Amt1,'0')) gum1, SUM(Decode(O.S_Bun,98,O.Amt1,'0')) gum2, SUM(Decode(O.S_Bun,99,O.Amt1,'0')) gum3 FROM OPD_SLIP O WHERE Patient_no = '00000001' And B_Date >= TO_DATE('01-Jan-2005','DD-MON-YYYY') And B_Date Select SEQ_NO , Group by 절 SEQ_NO // 프린트 설정 Program : OpdMai..