Help me filter and select some columns on 2 different tables

1

n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a

2

hi

i did some correcting and formatting
but god knows what your issue is

any how

do you know how to build one step at a time
errors in thinking

SELECT        
     v_clms220225.ctr v clms220225.cif_no
  ,  v_clms220225.note_no
  ,  v_clms220225.prod_type
  ,  v_clms220225.nama
  ,  v_clms220225.plafon_awal
  ,  (vd_cntclac2m.total60 + vd_cntclac2m.total62) AS "Total60+Total62"
  ,  vd_cntclac2m.total60
  ,  vd_cntclac2m.total62
  ,  v_clms220225.baki_debet
FROM       
    v_clms220225
       INNER JOIN 
	vd_cntclac2m
        ON  vd_cntclac2m.substr(agree id,9,18) = v_clms220225 concat(OF no,note_no)
WHERE      
    v clms220225.prod_type=901
        AND        
	(vd_cntclac2m.total60+ vd_cntclaczm.total62) != v_clms220225.plafon_awal
1 Like
3

n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a