Dennis
7/26/2018 - 2:53 PM

FS Quiz Results extra

SELECT a.SubscriberKey, a.EmailAddress, a.session_id, a.firstname, a.prefix, a.lastname, a.slug, a.score, a.gender,
c.question_text, d.answer_text, e.quiz_title
FROM [FS Results] a
INNER JOIN [FS Response] b ON a.session_id = b.session_id
INNER JOIN [FS Question] c ON b.question_id = c.question_id
INNER JOIN [FS Answer] d ON b.answer_id = d.answer_id
LEFT JOIN [FS Quiz] e ON c.quiz_id = e.quiz_id