Chapter 24, Problem 13RE

Explanation of Solution

Consider the following:

The below SQL statement that select and list all line items that are part of invoice number 11731:

/* Display all the records from the table */

SELECT Product.Description, LineItem.Quantity

FROM Product, LineItem

WHERE LineItem.Invoice_Number = 11731

AND LineItem.Product_Code = Product.Product_Code

Explanation:

• The above “SELECT” statement that retrieves all records of “Product.Description” and “LineItem.Quantity” columns from the “Product” and “LineItem” tables where “LineItem.Invoice_Number” is equal to “11731” and “LineItem.Product_Code” is equal to “Product.Product_Code”.
  • “Product.Description” – It refers to the “Description” column in the “Product” table.
  • “LineItem.Quantity” – It refers to the “Quantity” column in the “LineItem” table.
  • “FROM” – It is a keyword used to refer the tables from where the data has to be extracted...