No results returned by this query.
Query text (visible by Query Admin only):
SELECT sch.crs_cde, sm.crs_title, sch.id_num, nfbv.last_first_mi, fup.lastlogin FROM tmseprd.dbo.student_crs_hist sch, tmseprd.dbo.reg_config rc, tmseprd.dbo.section_master sm, tmseprd.dbo.name_format_basic_view nfbv, ics_net.dbo.fwk_user fu, ics_net.dbo.fwk_userproperty fup WHERE ( sch.yr_cde = rc.cur_yr_dflt ) and ( sch.trm_cde = rc.cur_trm_dflt ) and ( sch.yr_cde = sm.yr_cde ) and ( sch.trm_cde = sm.trm_cde ) and ( sch.crs_cde = sm.crs_cde ) and ( sch.id_num = nfbv.id_num ) and ( sch.id_num = fu.hostid) and ( fup.UserID = fu.id) and ( ( sm.lead_instructr_id = @@HostID ) AND ( sch.transaction_sts = 'C' ) ) order by sch.crs_cde, fu.lastname, fu.firstname, fu.middlename