Hi Robin,
Use a standard select like you normally would, and in your where clause,
use "where [field] is null" :
select field1[, field2, ...] from table1[, table2, ...] where fieldx
is null [...]
-bsh
Robin McKenzie wrote:
>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
>
>
>
--
/---------------------------------------------=[ BILLY S HALSEY ]=--\
| Member of Technical Staff, Sun Microsystems, Inc. ESP Solaris SW |
| "All opinions and technical advice offered in this message are my |
| own and not necessarily endorsed by my employer." |
\--=[ [EMAIL PROTECTED] ]=--------------------------------------------/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
