Question

Hi All,
I'm trying to answer the following SQL question using MySQL & I would greatly appreciate some help:

List the customers who have a balance due on a tour:
Customer Name
Tour Name
Start Date
Tour Cost
Amount Paid
Amount Due

This is what I have thus far (incorrect):
mysql> Select CONCAT( FName, ' ', LName ) AS "Customer Name",
TourName AS "Tour Name", TourStartDate AS "Start Date", Cost AS "Tour Cost",
SUM(PaymentAmt) AS "Amount Paid", ( Cost - SUM(PaymentAmt) ) AS "Amount Due"
FROM Customers INNER JOIN Tours INNER JOIN Payments
WHERE NOT E

Answer 1

to do inner join, you need something like "FROM Customers INNER JOIN Tours ON Customers.id = Tours.id INNER JOIN Payments ON Tours.id = Payments.id"