MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: NOT IN synthax in mysql
Posted by: Mark Leith
Date: March 15, 2005 08:41AM

If you are on version 4.1 :

Exactly like that! ;)

If you are on a version prior to 4.1, you will need to use a JOIN. Check out:

http://dev.mysql.com/doc/mysql/en/JOIN.html

The JOIN syntax allows a "Self-Join" (joining a table to itself)..

HTH

Mark

Mark Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
NOT IN synthax in mysql
2943
montreal montreal
March 14, 2005 12:32PM
Re: NOT IN synthax in mysql
2077
Mark Leith
March 15, 2005 08:41AM
Exception Handaling in stored procedure
2248
Shalmi Patel
May 23, 2005 06:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.