Hi,
I am new to this list, so maybe this question is asked before.
I like to know how to use the except statement in MYSQL. EXCEPT is
(almost?) the same as an exlusive or (XOR):
select userid from user1
except
select userid from user2
The result is a data set containing userid's that are only availlable in
user1 or in user2. If the userid is availlable in user1 AND user2, then it
won't be availlable in the result.
The question is what syntax to use in MYSQL to achieve this result!
Thanks in advance,
Viktor v/d Berg - The Netherlands
PS If the query isn't to complicated you can achieve a lot with a where
stament, but I use a lot of INNER JOIN's, so EXCEPT would be perfect in my case!
---------------------------------------------------------------------
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
