Left Outer Join problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Job.JobID
Job.Descr

TableB.JobID
TableB.SeqID

TableC.SeqID
TableC.Descr
___________________

Using inner joins I have linked as follows:
Job.JobID to TableB.JobID (one to many)
TableB.SeqID to TableC.SeqID (many to one)

Result is fine EXCEPT there are some Jobs missing.
This is because not all JobIDs have records in TableB.
___________________

So it seems I need a left outer join.
But when I change the links from the Job table to TableB
I get "Failed to Open Rowset - SQL query error."

If I join all three tables with left outer I don't get an
error but jobs with no TableB records do not show up.
 
Create a query on the first two tables only with a left join on Job.
JobID=TableB.JobID (output all fields). This will show all Job.JobIDs
regardless of a match in TableB. Save the query object and then use it along
with TableC to create a left join on newquery.SeqID=TableC.SeqID. HTH
 
Back
Top