update dr_crs_offered_cyr b,sr_crs_grd a
set b.credit_lvl = 'H'
where a.sch_yr = b.sch_yr and a.crs_nbr = b.crs_nbr and b.credit_lvl <> 'H' and a.campus_id = '001';
commit;