I have attached a simplified version of what i am trying to achieve in one of my databases.
In this example, i have 4 tables.
tblEmployee
tblTask
tblBudget
tblSpent
I am trying to write a query that will return all budgets and hours spent for each of the tasks. I want the results to show Total budget and spent hours per employee per task including Employees that have spent hours against a task that they do not have budgets for.
So with the tables i have attached The results would need to show
Task Employee BudgetHours SpentHours
--A-----1----------10----------5
--A-----2----------0-----------2
--B-----1----------10----------0
--C-----1----------10----------0
Thank you, and I apologize if I made this sound confusing.
Ryan