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 >> from t1 as new >> left join project on new.projectdesc=project.projectname >> where project.projectname=NULL > > rewrite the last part of the query to be projectname is null. All tests > for equality involving null will return null, hence your query wouldn't > return any rows. > > Ryan > > --------------------------------------------------------------------- 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