Public Holiday and Calendar events join with employee assignments
SummaryPublic Holiday and Calendar events in Exception of work schedule
and cov.calendar_event_id = ev.calendar_event_id
and ev.calendar_event_id = eve.calendar_event_id
and eve.CATEGORY = 'PH' --- 'Public Holiday
Above query and tables are for calendar events that are having Public Holidays.
I need to link those tables with employee assignments.
Please help me