Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Awards in multiple SP files should not be reported in most recent file.

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)

  • No labels