Query help needed

[jensemann]

time they answer a question correctly, it should appear in this table. as a username and question id.

The connection/table is:

table one: question id - subject id
table to: question id - subject id - username

I want to check if the user has answered the question - that is: there is an entry in the second table

What I need to do is:
If the user is logged in, and he wants to see a list over all questions he has not answered, the following need to be done:
compare the question id and subject id where the username is matching. If the question id and subject id is matching in the two tables, then show
table one, EXCLUDING the matching data from table two.

How can I do this?

Thanks

[liquorvicar]

Try

SELECT question_id FROM table_one WHERE question_id NOT IN (SELECT question_id FROM table_two WHERE username='my_username')

I'm assuming question_id is a unique ID.

[jensemann]

That was excatly what I was looking for.

Thank you so much!!

[liquorvicar]

Don't forget to mark the thread resolved using thread tools.