List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:January 9 2002 6:10pm
Subject:mysql query
View as plain text  
I am trying to write a query that gets the name of every carrier who has done more than
$600 
in loads.  Can anyone help?

    SELECT c.name
    FROM carrier c, loads l
    WHERE c.CID_NO = l.CID_NO
    AND SUM(l.amount > 600);

This, unfortunately does not work.






Thread
mysql queryRichard Reina9 Jan
RE: mysql queryTyler G. Nally9 Jan