I am trying to list items in t1 (alias new) that are not in project so I
tried the query suggested on an earlier mail:
select new.projectdesc,project.projectname
from t1 as new
left join project on new.projectdesc=project.projectname
where project.projectname=NULL
| projectdesc | projectname |
You are testing nullity using equal, but you must use IS NULL to test against
NULL values.
http://www.mysql.com/doc/C/o/Comparison_Operators.html
On Tuesday 18 June 2002 15:11, Phoebe Bright wrote:
I am trying to list items in t1 (alias new) that are not in project so I
tried the query
On 18 Jun 2002, at 19:11, Phoebe Bright [EMAIL PROTECTED] wrote:
select new.projectdesc,project.projectname
from t1 as new
left join project on new.projectdesc=project.projectname
where project.projectname=NULL
| projectdesc | projectname |
Number of Results: 0
You can't use = with
Thanks!
Phoebe.
on 18/6/02 19:32, Ryan Fox at [EMAIL PROTECTED] wrote:
On Tue, 2002-06-18 at 14:11, Phoebe Bright wrote:
I am trying to list items in t1 (alias new) that are not in project so I
tried the query suggested on an earlier mail:
select new.projectdesc,project.projectname