select e.eventId, e.eventName, e.surveyId, e.partnerId, e.partnerType, ed.eventDay, ed.eventDate, comments from tbl_EVT_Events e inner join tbl_EVT_EventDates ed on e.eventid = ed.eventid where e.eventId = and e.ownerid = and e.ownerType = select m.firstname, m.lastname, m.Fspro_userid, m.email from tbl_FSpro_Members m where m.fsl_TableCode = and m.ownerid = and m.fspro_UserID IN () order by lastname ,firstname