At 12:21 +0100 10/10/02, Victor Kirk wrote: >Hi, > >I have two tables, one for user details and another to indicate >membership of some team. The later has user_id and team_id. I >want to select all users that are NOT in a particular team. > >After a lot of effort (my sql skills are almost no existent) I >have the following that works with Oracle. > >SELECT u.uname FROM users u > WHERE NOT EXISTS (SELECT * FROM team_members > WHERE team_id = 7 AND user_id=u.user_id); > >This doesn't work with MySQL :-(
... until MySQL 4.1. :-) Now available for testing: http://www.mysql.com/doc/en/Installing_source_tree.html > >Can anyone help me? Ideally I would like something that would >be portable to oracle/sql server. Efficiency is not an issue. > >Vic >-- --------------------------------------------------------------------- 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
