List employees who have Intersect traveled to both Chicago MySQL does not support Use a Intersect. and New York subquery. (Note: cannot be done The operator returns only those records Intersect using just a join) that appear in both temporary tables. Normally, the query requirements will include word “AND”. Duplicate using an In subquery List employees who have Minus traveled to Chicago but MySQL does not support Use a subquery. Minus. not New York The operator returns the records from the first Minus query with any matching records from the second query removed. Normally, the query requirements will include the words “BUT NOT” Duplicate using a Not In subquery Any and All and allow you to create queries that compare Any All a value in a record with a list of values supplied by a subquery. As far as I can tell, and queries can Any All alternatively be accomplished using (Select or subqueries Min(value) From table) Max(Value) appropriately Examples:
Intersect MySQL does not support Intersect. Use a subquery. The Intersect operator returns only those records that appear in both temporary tables. Normally, the query requirements will include word “AND”. Duplicate using an In subquery List employees who have traveled to both Chicago and New York (Note: cannot be done using just a join) Minus MySQL does not support Minus. Use a subquery. The Minus operator returns the records from the first query with any matching records from the second query removed. Normally, the query requirements will include the words “BUT NOT” Duplicate using a Not In subquery List employees who have traveled to Chicago but not New York Any and All Any and All allow you to create queries that compare a value in a record with a list of values supplied by a subquery. As far as I can tell, Any and All queries can alternatively be accomplished using (Select Min(value) From table) or Max(Value) subqueries appropriately Examples:
4%20-%20Multi-Table%20Queries.docx