I have two tables one contains quiz scores the other contains users. When a user completes a quiz they are entered in the scores table.
Firstly I need to select user id's from the scores table based on a particular quiz. e.g.
SELECT user_id from scores where quiz_id = 13.
I then need to search the user table to find every user who hasn't completed the quiz.
Hope this makes sense
Firstly I need to select user id's from the scores table based on a particular quiz. e.g.
SELECT user_id from scores where quiz_id = 13.
I then need to search the user table to find every user who hasn't completed the quiz.
Hope this makes sense