Hello,
I think this is fairly easy, but I don't know what I'm doing. I have three different tables that track the progression of different users on different projects. I need to combine these three into 1 querry that will tell me the number of each status.
Right now I have 5 tables in total
1)Owners
Owners
Tom
Bob
Jill
John
2)Projects under 5M
Owners Status
Tom Incomplete
Bob Complete
Tom Complete
3)Projects over 5M
Owners Status
Jill Incomplete
John Complete
Jill Complete
3)Misc
Owners Status
Bob Incomplete
Tom Complete
Tom Complete
I also created a table called status, but dont know if it's necessary
5) Status
Status
Complete
Incomplete
In Progress
I need a count of how many projects are complete, incomplete, in progress across all three tables