+ "sharer.participant_name as o_sharers_participant_name, "
+ "sharer.tenant_id as o_sharers_tenant_id "
+ "from tbl_vw_calendar as cal left outer join tbl_vw_calendar_sharer as sharer "
+ " on cal.calendar_id = sharer.calendar_id "
+ "where (cal.tenant_id = ? and cal.calendar_id = ?)",
new JoinOn("calendar_id", "o_sharers_calendar_id"),
aTenantId,
aCalendarId);
}