SELECT Keywords

1234567891011121314151617
Across
  1. 1. Clause that lists the tables used by the query.
  2. 4. Evaluate the right hand source once for each row in the left and only return a row if there is a result.
  3. 9. ______.b.c.d
  4. 10. Return only the rows that match.
  5. 12. Return all rows on both sides of the join.
  6. 13. Return all rows on the left, and only the matches on the right.
  7. 15. Alias
  8. 16. Combine the data from two queries, but only return distinct rows.
  9. 17. The only required keyword of a select statement.
Down
  1. 2. Creates a group for each combination of column expressions in the GROUP BY and provides subtotals and totals.
  2. 3. Join two 100 row tables and get 10,000 rows returned.
  3. 5. Return all rows on the right, and only the matches on the left.
  4. 6. Combine the data from two queries.
  5. 7. Most conditions on a query go here.
  6. 8. a.b.______.d
  7. 11. Compare the data between two queries and only return matches.
  8. 14. Return everything on the left that doesn't exist on the right.