Chapter 23, Problem 11RE

Explanation of Solution

SQL query that lists all customers who have an unpaid invoice:

The following “SELECT” statement selects all customers’ names that have an unpaid invoice:

/* Display the lists of unpaid invoice*/

SELECT Name

FROM Customer, Invoice

WHERE Customer.Customer_Number = Invoice.Customer_Number

AND Invoice.Payment = 0;

Explanation:

• The above “SELECT” statement that fetches all customers “Name” from the “Customer” and “Invoice” table where “Customer.Customer_Number” is equal to “Invoice.Customer_Number” and “Invoice.Payment” is equal to “0”.
  • “Name” – It refers to the column name from which data is extracted.
  • “Customer” & “Invoice” – It is the name of the table from which the information is retrieved...