MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2947
March 14, 2005 12:32PM
Re: NOT IN synthax in mysql
2080
March 15, 2005 08:41AM


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.