Hello, thank you for helping with this query; it works perfect.

How would I display data for a specific quiz ID? Table is c_quiz_id.

SELECT
QU.c_date_time,
U.name,
QU.c_quiz_id,
QU.c_total_score,
QU.c_passing_score,
QU.c_max_score,
QU.c_passed,
QU.c_total_time,
U.email
FROM
#__quiz_r_student_quiz QU INNER JOIN #__users U
ON QU.c_student_id = U.id

example would only like to display above results for quiz 5 only.

Hello,

Use the following query:

SELECT
QU.c_date_time,
U.name,
QU.c_quiz_id,
QU.c_total_score,
QU.c_passing_score,
QU.c_max_score,
QU.c_passed,
QU.c_total_time,
U.email
FROM
#__quiz_r_student_quiz QU INNER JOIN #__users U
ON QU.c_student_id = U.id
WHERE
QU.c_quiz_id = 5

Regards,
ARI Soft

Awesome! and if I wanted to report on just quiz 5 and 2?

Thanks in advance...

Use the following query:


SELECT
QU.c_date_time,
U.name,
QU.c_quiz_id,
QU.c_total_score,
QU.c_passing_score,
QU.c_max_score,
QU.c_passed,
QU.c_total_time,
U.email
FROM
#__quiz_r_student_quiz QU INNER JOIN #__users U
ON QU.c_student_id = U.id
WHERE
QU.c_quiz_id IN (2,5)

Regards,
ARI Soft