Display event form data on details page.

[marysaray]

• Event Title
• Category from {EventType}
• Event Description
• Start Date Time
• End Date Time
• Host Name from {ContactInfo}
• Contact Number from {ContactInfo}
• Location Name from {Location}
• Street Address from {Location}
• [City], [State] [Zip] from {Location}

[marysaray]

SELECT EventTitle,
    Description,
    StartDateTime,
    EndDateTime,
    Category,
    FirstName,
    LastName,
    PhoneNumber,
    LocationName,
    StreetAddress,
    City,
    State,
    Zip

FROM EventForms AS EF
    JOIN Categories ON
    EF.Id = Categories.EventId
    JOIN Contacts ON 
    EF.Id = Contacts.Id
    JOIN Locations ON
    EF.Id = Locations.LocationId