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 NULL (well, you can, but you'll always get NULL as the result of the comparison). Change the WHERE clause to WHERE project.projectname IS NULL You might want to read this: http://www.mysql.com/doc/P/r/Problems_with_NULL.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
