So I've got a basic SQL question that I can't seem to work out. The query is: "Obtain all the invoices of customers who have ever had an invoice over $100".
Here's the SQL fiddle I've been using: http://ift.tt/1Nwszh9
The things I've been trying is like:
SELECT * from Invoice I
INNER JOIN Customer C ON C.id=I.customer where I.inv_total > 100.00;
But it's not working... any help is appreciated :)
Aucun commentaire:
Enregistrer un commentaire