> Select * from employees left outer join dept on employees.emp_DepId = > dept.dep_id where dept.dep_id is null > > (Subselect would be easier if MySQL supported it!)
Likely easier to write, but equally likely to be more expensive to run (on any tbl of realistic size) NB Comment only pertinent as size or query-run frequency grows. Try testing it out on Oracle or an RDBMS that allows sub-selects! =dn --------------------------------------------------------------------- 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
