1 Reply Latest reply: Jun 15, 2011 5:49 PM by Jono_CRMNow RSS

    Fields from 2 different Subject Area via inner or outer join

    600713
      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)     
      col1,col2----------------------------col2,col3-----------------------------------col1,col2,col3

      Please let me know how to achieve this