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 | Number of Results: 0 So I tried running without the where clause: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname | projectdesc | projectname | | | NULL | | NULL | NULL | | Area | NULL | | Accounting | Accounting | | Admin | NULL | | Marketing | NULL | | Management | NULL | | Production | NULL | | Research | NULL | | Sales | NULL | | Technical Development | NULL | Number of Results: 11 Have I missed something obvious????? --------------------------------------------------------------------- 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