OOB Joins are Left Outer from Parent to Child forms. Not Full Left/Right Outer..
Someone else may have additional thoughts on how to simulate a Full Outer join within the confines of AR System joins, but as far as I know what you are trying to do may have to be rethought for a different approach.. Janie _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, July 23, 2008 9:43 AM To: [email protected] Subject: Full Outer Joins? Does AR System support Full Outer Joins on a Join Table? I need to combine the results of both left and right outer joins. The joined table will contain all records from both tables, and fill in NULLs for missing matches on either side. Our environment: AR Server 7.0.1 Patch 3 MT 7.0.1 Patch 5 Oracle 10i Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
