There is always the option to create a join view in the database and throwing a view form on top of that. It would allow you to perform database functions that Remedy just won't do.
HTH, Brian On Wed, Jul 23, 2008 at 12:44 PM, Janie <[EMAIL PROTECTED]> wrote: > ** > > 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___ __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"
