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
