From: "Larry Sandwick" <[EMAIL PROTECTED]>
> I need to sum the field *COST* in this query where data in *STATUS* is
> equal to "HELD" and "OPEN", so I will have 2 totals passed below and do
> not know where to begin .

SELECT status, SUM(cost) FROM Table WHERE status IN ('HELD','OPEN') GROUP BY

---John Holmes...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to