SELECT DISTINCT [_vw_EVT_Calendar].[org_ID], [event_DateFrom] FROM [_vw_EVT_Calendar] LEFT JOIN _CRM_orgXfac ON [_vw_EVT_Calendar].org_ID = _CRM_orgXfac.org_ID WHERE ([_vw_EVT_Calendar].[org_ID] = @partner) AND ([evtcatid] = 3) ORDER BY [event_DateFrom]