SELECT	DISTINCT e.eventId, e.eventName, ed.eventDate eventStartDate, x.eventDate as eventEndDate, e.comments, e.partnerId, e.partnerType
	FROM	tbl_EVT_Events e
		inner join tbl_EVT_EventDates ed on e.eventid = ed.eventid and 	ed.eventDay = 1
		inner join (
			select ed1.eventID, max(ed1.eventDate) as eventDate
			from tbl_EVT_EventDates ed1 
			group by ed1.eventID) as x on e.eventid = x.eventid