hey all, using mysql ver 3.23.36
got stuck with something, here's a simplified example of it: +---+---+ | a | b | +---+---+ | 1 | 1 | | 1 | 2 | | 2 | 2 | | 3 | 1 | +---+---+ I would like to retrieve the set of all a where b !=2 so in the above example, only 3 would be returned... but a simple query like "select a from table where unfortunately unless I use subselect I have no clue how to do this... --------------------------------------------------------------------- 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
