Notice that Wayne is listed as a member in project A (Table 2) but has not worked any hours for project A (Table 1).
Also, Billy is listed as a member of project B (Table 2) but is not listed in Table 1 at all.
Is there a way I can show each circumstance of:
1) showing when somebody is listed as being on a team in table 2 but does not have any hours for that project in table 1 (they could have hours on other projects)
2) showing people listed as being on a project in Table 2 but not even listed in Table 1
I'm trying to create some exception reports that will help me maintain a database that has become sloppy over the years (and to prevent any future situations)
if i can suggest...
I think you must change the conception of your table2.
You can not find information that you require easily
You can not have more tree member in a project
You must change like this
Order (if it's important for you)
But this implies can be of large modification of your application... and i dont no find any other thing for help you