Gary Williams
03-01-2008, 12:46 AM
Hi All,
I can't solve this inner join problem. I've worked through the '4guysfromrolla' tutorial and that all makes sense but I can't transfer it to this problem.
I have a table (see Table - Jobs) that records each job plus the operator who worked on it and the services applied. Each operator (see Table - Operator) has a set of services they are trained for (see Table - Operator_Service). The title/description of each service is specified in Table - Service.
I need to produce two reports. Report1 is a list of all operators and the service they are trained for. Report 2 is a list of daily jobs, identifing the operator (by name) and services applied (by title/description).
I can't get my head around the nesting of these tables by inner joining to produce the reports.
I have attached the tables and what the two reports should look like as a pdf.
Regards
Gary
I can't solve this inner join problem. I've worked through the '4guysfromrolla' tutorial and that all makes sense but I can't transfer it to this problem.
I have a table (see Table - Jobs) that records each job plus the operator who worked on it and the services applied. Each operator (see Table - Operator) has a set of services they are trained for (see Table - Operator_Service). The title/description of each service is specified in Table - Service.
I need to produce two reports. Report1 is a list of all operators and the service they are trained for. Report 2 is a list of daily jobs, identifing the operator (by name) and services applied (by title/description).
I can't get my head around the nesting of these tables by inner joining to produce the reports.
I have attached the tables and what the two reports should look like as a pdf.
Regards
Gary