 | I know that the 4 table join has been covered before, but I can't find
an example to do what I'm trying to do...
I have 4 tables
Volunteers
*VolID
First
Last
Jobs
*JobID
&RoleID
StartTime
EndTime
Roles
*RoleID
Role
VolJobLink
&VolID
&JobID
Confirmation
I want a table that will show me all of my volunteers regardless of
whether they are assigned to a job -- but to show me the role, start
time, and end time if they are assigned to a job.
Is this possible with a single query?
Chris
|
|
