Grad Fair Attendance list - How to Pull A
Problem Description :
How to pull a Grad Fair Attendance List
Resolution :
select
ID,
LFM_name,
email_address
from wsclgad, wscevnt, v_person vp
where wsclgad_eventid = wscevnt_eventid
and wsclgad_pidm = vp.pidm
and wscevnt_eventid = 'GRAD'
and wsclgad_date >'21-MAR-2017'
Revision Date : 3/24/2017