Subject | Re: [IBO] Calculating data |
---|---|
Author | |
Post date | 2014-09-05T11:59:34Z |
Hi Marcin, I need help coding the trigger.
I have a relational database with 2 tables. The primary and the secondary as shown. If you add up the hours worked in the secondary table for Smith it is 24 so hours in the primary table = 24
Primary Table
id surname hours
100 smith 24
Secondary Table
id Work Hours
100 McDonalds 10
200 BMW 6
100 Google 8
100 Microsoft 6
300 Oracle 5
Any help would be appreciated.
Terry