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