SQL

Edit Answers
123456789101112131415161718
Across
  1. 6. to specify which field in which table you are referring
  2. 7. a clause included in a command that calculates totals for a certain group of records
  3. 9. to find rows in two tables that have identical values in matching fields
  4. 12. an Access wildcard that represents a collection of characters
  5. 13. consists of the tables involved in an SQL expression
  6. 16. the SQL data with the form: field name, comparison operator, and another field name or a value
  7. 17. used in SQL to update tables and retrieve info from them
  8. 18. an inner query
Down
  1. 1. functions with groups similarly to the way WHERE functions with rows
  2. 2. a query expressed using the SQL language
  3. 3. the commands that are used to retrieve data
  4. 4. the language for querying and updating a database
  5. 5. includes the list of fields in an SQL expression
  6. 8. fields not included in the database but are calculated from fields that are
  7. 10. criteria formed by connecting two or more simple criteria using AND, OR and NOT
  8. 11. to sort an SQL output, you use this clause
  9. 14. includes any criteria that the data you want to retrieve in an SQL expression must satisfy
  10. 15. alternative name