```
SELECT quotes.qid, SUM(qitems.net_cost_ext)
FROM quotes, qitems
WHERE quotes.qid = qitems.qid
GROUP BY qitems.qid;

UPDATE quotes, qitems
SET quotes.net_cost_total = SUM(qitems.net_cost_ext)
WHERE quotes.qid = qitems.qid
GROUP BY qitems.qid;

```

The above select statements sums up the net cost for all the products on each quote and displays the sum by quote number. 

I added a net\_cost\_total field to the quotes table. I want to update all the quotes with the net\_cost totals from each quote. The query fails, it says the GROUP syntax is bad, I'm not sure how else to go about this.