[SOLVED] select values from table those are not present in the another table

[deepson2]

Hello,

 

I want to calculate how many quizes user has not played. basically i have two table. In one table i am storing all question and answer with quizid and the table name is truefalse. In the another table i am storing the quiz information of user has played and table name is quizuser.

 

so i was trying the following query. but this is using left joint. i want to consider userid as well.

 

 

SELECT * FROM `truefalse`LEFT JOIN quizuserON truefalse.quizid= quizuser.quizidWHERE quizuser.quizid IS NULL

 

 

Ex- if A is user who has userid=1 And he has played 5 quizes out of 10. so i want to show remaing five quizzes to him. How can i do that.

 

thanks in advance.

 

 

[kickstart]

Hi

 

Like this:-

 

SELECT * FROM `truefalse`

LEFT JOIN quizuser

ON truefalse.quizid= quizuser.quizid AND quizuser.userid=1

WHERE quizuser.quizid IS NULL

 

All the best

 

Keith

[deepson2]

Hello Keith,

 

Well, do i need to say that the query is working??

 

Yes its working.

 

Thanks a lot!!