Page Comparison

select *
  from [Student_Program_Award] a
 where a.GI03_MIS_TERM =210 and
exists( select pidm from [Student_Program_Award] b where b.GI03_MIS_TERM =200 and a.sp01_program_id=b.sp01_program_id and a.SP02_PROGRAM_AWARD=b.SP02_PROGRAM_AWARD
and a.SP03_PROGR_AWARD_EARN=b.SP03_PROGR_AWARD_EARN and a.SP04_PROGRAM_CO_UNIQUE_CODE = b.SP04_PROGRAM_CO_UNIQUE_CODE)