I need to be able to check if rows in table Input are there in table Transform and if they are not present in table Transform ,then I need to see those rows in Input not present in Transform.
the primary keys in input are st1,st2,st3.
the primary keys in transform are jt1,jt2,jt3.
I am checking to see if st1=jt1 and st2=jt2 to see if rows in input match to rows in transform.
could you guys give me some sample code for this.