try corereader. it will run queries against your mysql, oracle, and ms sql server (and anything else laying around). you can switch between your servers with a click.
peter brawley gives your answer in another message, but you can quickly work out those simple queries with point and click in corereader. it's a free download at http://corereader.com/ > 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 :-( > > Can anyone help me? Ideally I would like something that would > be portable to oracle/sql server. Efficiency is not an issue. > > > Vic > -- > > > This message, including attachments, is intended only for the use by the > person(s) to whom it is addressed. It may contain information which is > privileged and confidential. Copying or use by anybody else is not > authorised. If you are not the intended recipient, please contact the sender > as soon as possible. The views expressed in this communication may not > necessarily be the views held by Serco Integrated Transport. > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- 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