0 Replies Latest reply on Dec 12, 2017 10:04 PM by WyoJohn

    Correlated Sub-select in Peoplesoft Query?

    WyoJohn

      Hi All,

       

      I'd like to do a correlated sub-select for several fields in the top of my query. Can I do this within the Peoplesoft Query Manager or do I need to do this as a Connected Query?? If I can do this inside of the Peoplesoft Query Manager, can you offer some tips for how to do this?

       

      The SQL I'm using looks something like this. I get the Project ID from T1 and match it in my sub select to get the Project Name:

       

      SELECT

      T1.*,

      (*/ Query 2 */ Select X.Project_Name From tablex X Where T1.Project_ID = x.Project_ID ) as "Project Name"


      FROM

      (

      */ Query 1 */

      SELECT A.Project_ID, B.*

       

      From

      TablesA A,

      TablesA B

       

      Where

      A.id = B.id

       

      ) T1