I have 3 tables as following:
Table Employees with columns Name, Email.
Table Timesheet with columns Name, Project, Time in, Time out, Total hours.
Table Projects with columns Project, Total Hours.
How can I create a view for “total hours for each project by each name”?
User | Count |
---|---|
35 | |
34 | |
27 | |
23 | |
18 |