The opposite of the IN operator?
Posted on 2006-06-29
Hi - instead of using an IN operator, that gets values that are in both fields specified (adds them), what operator do you use to get values that are only in both fields specified (subtracts them)?
For ex, imagine this table:
I want to do a sql query that gives me what is common between a "ford" and a "toyota" -- which should result in the correct answer, "van". This would all be in one table.