> I am fairly new at using Firebird SQL and I would like some direction on how > to include some calculations into my code. > > For example I want to read a table, group by a part number and then get a > total price for all the items in the group. Would this be something for a SP? > > I have looked online but couldn't find a complete answer.
You haven't told us your tables and possibly a first try of your SQL, but the following might put you into the right direction. select part_number , sum(prize) from yourtable group by part_number -- With regards, Thomas Steinmaurer http://www.upscene.com/
