IN and EXISTS
IN
- Tests for membership in a set: x ? A
- Binary operator returning Boolean value
- used within conditions (WHERE)
- left side a row (or value construed as a row)
- right side a table, frequently the result of a (nested) SELECT
EXISTS
- Unary operator returning a Boolean
- tests a table for non-empty: A??