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