|List:||General Discussion||« Previous MessageNext Message »|
|From:||Richard Reina||Date:||January 9 2002 6:10pm|
|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.
|• mysql query||Richard Reina||9 Jan|
|• RE: mysql query||Tyler G. Nally||9 Jan|