What steps should you take to join (relate) tables?
What will be an ideal response?
1. In the SELECT clause, list all columns you want to display.
2. In the FROM clause, list all tables involved in the query.
3. In the WHERE clause, list the condition that restricts the data to be retrieved to only those rows from the two tables that match; that is, restrict it to the rows that have common values in matching columns.
You might also like to view...
________ macros are triggered by database events
A) Embedded B) AutoExec C) AutoKey D) Data
Using a logical process to find and reduce the number of errors in a program is known as:
A) running. B) testing. C) analysis. D) debugging.
Four task ____________________ define the relationships between tasks in a project.
Fill in the blank(s) with the appropriate word(s).
Google sells ____ online.
A. shoes B. auction space C. browser use D. advertising