Hello, I have a table "CustomerTypeOfWork" : - Id - CustomerId (FK) - TypeOfWorkId (FK) - HourByWeek
A table "Scheduled" : - Id - CustomerTypeOfWork (FK) - HourByWeek I'd like for one customer, get for each TypeOfWork he asked the total of HourByWeek scheduled. A customerTypeOfwork can be scheduled several time by to have the total needed by "CustomerTypeOfWork.HourByWeek" How can I do this ? Can I do this in one query ? Thanks, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
