Hi all,

I have 3 tables:

Payroll
- PayrollID
- JobID

Job
- JobID
- JobNumber
- JobDivisionID

JobDivision
- JobDivisionID
- JobType

and I want a query showing

PayrollID, JobNumber, JobType

Can I link in the 3rd table (JobDivision) in my query below?

Select  Payroll.PayrollID, Job.JobNumber
FROM Payroll
LEFT JOIN Job ON Payroll.JobID = Job.JobID

if I cannot use a single query, what is another way?

Thank you.

Regards,
Pat

Pat

> I have 3 tables:
>
> Payroll
> - PayrollID
> - JobID
>
> Job
> - JobID
> - JobNumber
> - JobDivisionID
>
> JobDivision
> - JobDivisionID
> - JobType
>
> and I want a query showing
>
> PayrollID, JobNumber, JobType

Select  Payroll.PayrollID, Job.JobNumber,JobDivision.JobType
FROM Payroll
LEFT JOIN Job ON Payroll.JobID = Job.JobID
JOIN JobDivision ON Job.JobDivisionID=JobDivision.JobDivisionID

John

>Select  Payroll.PayrollID, Job.JobNumber,JobDivision.JobType
>FROM Payroll
>LEFT JOIN Job ON Payroll.JobID = Job.JobID
>JOIN JobDivision ON Job.JobDivisionID=JobDivision.JobDivisionID

Thanks John, works great

Pat