Lisa, A Left Outer join gives you all records from Left, and only those from Right that match the join criteria.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Thursday, October 27, 2011 12:04 PM To: [email protected] Subject: Join Forms and Outer Joins ** If I have a join form with an outer join, doesn't that mean that the join form should have all records from Form A and Form B? I have a join form that is joined by 2 fields (no other query or anything) and when I swap the forms for Form A to be primary I get different results than when I choose Form B to be a primary. Is it because I'm joining the forms using 2 fields instead of one? Or maybe it's always been that way, and I just need a vacation. Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile [email protected] 100 Amp Drive Harrisburg, PA 17112 <http://www.te.com/> www.te.com <http://www.te.com/> <http://twitter.com/teconnectivity> <http://www.facebook.com/teconnectivity> <http://www.flickr.com/photos/teconnectivity/> <http://www.linkedin.com/groups?gid=1591657> <http://www.youtube.com/teconnectivity> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<~WRD000.jpg>>
