Robin > That may work for a single field in a record that is NULL, but I'm trying to > join two tables, and report the lines that do not have an entry in the > second thus: > > Question Table > > Q_id Question > 1 Question 1 > 2 Question 2 > 3 Question 3 > 4 Question 4 > > Response Table > > R_id Member_id Q_id Response > 1 1 1 Yes > 2 1 3 No > > > So, member 1 has answered questions 1 and 3 - I want to find how to get the > q_ids of the remaining questions... > > Q_id > 2 > 4
Check out OUTER JOINs (RTFM: 6.4.1.1 JOIN Syntax) =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php