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_idQuestion
> 1Question 1
> 2Question 2
> 3Question 3
> 4Q
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_idQuestion
1Question 1
2Question 2
3Question 3
4Question 4
Response Table
R_
Pretty easy really
SELECT * FROM foo WHERE bar is NULL
- DON'T use quotes "NULL" is a valid string it is not the same as NULL
- Some DBMS's allow you to say bar = NULL but technically this is wrong
because NULL is undefined and cannot be equal to anything not even another
NULL.
- Also "" is n
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 (initiall
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