SELECT E.Add1, E.Add2, E.City, E.State, E.Zip, E.Country, E.Phone, E.Fax, XR.Exhib_ID AS Exhibitor_ID, XR.Description, XR.Exhib_status, XR.Product_Categories, XR.New_Exhibitor, XR.Is_member,
 EC.First_name, EC.Last_name, EC.Title, EC.Phone, EC.Fax, EC.Mobile_phone, EC.Email
 FROM XR_Event_Exhibs XR INNER JOIN Exhibitors E ON E.Exhib_ID = XR.Exhib_ID
 INNER JOIN (SELECT TOP 1 Exhib_ID, First_name, Last_name, Title, Phone, Fax, Mobile_phone, Email
			FROM Exhib_Contacts
			WHERE Exhib_ID = 17
			AND Contact_Type = 'Main'
			ORDER BY Create_Date desc) AS EC ON E.Exhib_ID = EC.Exhib_ID
 WHERE XR.Event_ID = 17
 ORDER BY XR.Exhib_ID