EBK BIG JAVA: EARLY OBJECTS, INTERACTIV
EBK BIG JAVA: EARLY OBJECTS, INTERACTIV
6th Edition
ISBN: 8220102010314
Author: Horstmann
Publisher: YUZU
Expert Solution & Answer
Book Icon
Chapter 24, Problem 12RE

Explanation of Solution

Consider the following:

The below SQL statement that selects all products that have been purchased by a customer in California:

/* Display all products purchased by customer */

SELECT Product.Description

FROM Customer, Product, Invoice, LineItem

WHERE Customer.Customer_Number = Invoice.Customer_Number

AND Invoice.Invoice_Number = LineItem.Invoice_Number

AND LineItem.Product_Code = Product.Product_Code

AND Customer.State = 'CA'

Explanation:

  • The above “SELECT” query that fetches all “Product.Description”  from “Customer”, “Product”, “Invoice”, and “LineItem” table where “Customer.Customer_Number” is equal to “Invoice.Customer_Number”, “Invoice.Invoice_Number” is equal to “LineItem.Invoice_Number”, “LineItem.Product_Code” is equal to “Product.Product_Code”, and “Customer.State” is equal to “CA”.
    • “Product.Description” – It refers to the “Description” column in the “Product” table.
    • “Customer”, “Product”, “Invoice”, and “LineItem” are names of the four tables from where the rows will be retrieved...

Blurred answer
Students have asked these similar questions
show all the work
answer question 3
Show the work
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education