>Something like this?
>
>

>SELECT line, SUM(lbs) AS sum_lbs FROM myTable GROUP BY line
>

Yeah, that's the idea, but with all fields, not just those two.
Or do I have to put in every field name in that case?