Please correct me if I am wrong:

1. columns used in the ORDER BY clause should be part of SELECT clause

2. columns used in the ORDER BY clause should be first part of the GROUP BY clause.

select id_number, description, sum(price) from inventory
where price > 0
group by id_nubmer
order by manufacturer_id

Which line causes error. I am guessing it is last line. Any suggesetions..

nath