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

Reply via email to