dimanche 8 mars 2015

SQL - Obtain all invoices of people that once had an invoice over $100

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