SELECTING FROM MORE THAN ONE TABLE (review)

Many of the examples and exercises that follow use more than one table, with one or more INNER JOINs. To review:

• Run the Order Details Extended query:

• Go to SQL for this query (ANSI style):

•  Separate the statement into its clauses (SELECT, FROM, INNER JOIN, etc.) and note the number of tables and the join condition(s). Do not save changes you make at this point.

• In a new SQL window, rewrite the SQL with the JOIN condition(s) in a WHERE clause.

Note: To simplify rewriting the query, omit the table names where not needed, use table aliases if you wish, and calculate the total price without discounting (that is, replace the "Extended Price" calculation) as follows:

[Unit Price] * Quantity AS NondiscountPrice

The Unit Price column appears in more than one table, so you will have to specify which table the database engine should use.