I have a table contains a project code, job code and quantity. I need to generate a result set that will show, uniquely, job codes that are used in any project and the total quantity of that job code across all projects. i.e.
projectcode jobcode quantity
AAAAAAAA A1 5
BBBBBBBB A1 4
CCCCCCCC A1 1
This would generate a result set of: A1 10
Any suggestions greatly appreciated.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.