1 Reply Latest reply on Jun 15, 2011 10:49 PM by Jono_CRMNow

    Fields from 2 different Subject Area via inner or outer join

      Hi All

      I have a requirement where I have to pull columns which are available in 2 different Subject Areas.
      For eg. Col1 and Col2 in one SubjectArea1/Report1 and Col2 and Col3(obviously not available in SubjectArea1) in second SubjectArea2/Report2.
      The resultant expected is a single report with Col1, Col2 and Col3.

      SUBJECTAREA1/REPORT1----     SUBJECTAREA2/REPORT2-----------     FINAL REPORT(on Inner/Outer join)     

      Please let me know how to achieve this