UNION cont.

• each statement must pull the identical number and type of fields.
• can combine two or more SELECTs
• do not need to pull FROM same table(s)
• can use table joins in any or all SELECTs
• do not need to use identical WHERE clauses