 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / February 2007Left Outer Join problem
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 >Job.JobID >Job.Descr [quoted text clipped - 20 lines] >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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.