Finding records with NULL values
| From: | Robin McKenzie | Date: | Tue, 26 Feb 2002 21:49:00 +0000 |
| Subject: | Finding records with NULL values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17312@lists.php.net to get a copy of this message | ||
I have a table of questions, and a table of responses (initially empty)
which gets updated every time an answer is submitted, with the question
number, member id and response.
I wish to produce a SELECT query that will find the questions that haven't
been answered by a particular member, i.e. a query that finds the questions
that DO NOT have an entry in responses. How can I do this?
Regards,
Robin