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