I am using PS 8.45.11 and Financials/SCM 8.80. I am trying to insert a table in PS query that I am using in a Crystal Report. The table is MEMBER_PHONE which come to find out is a Sub Record. When I insert it into my query it shows up as PHONE_SBR and only shows the fields in the sub record and not the key field that I need to join on.
I have tried writing an expression with the field that I need but it dosn't pass edit because the field is not listed in the query. I can successfully run it in my SQL editor. Here is the SQL that I wish to run.
SELECT PHONE FROM PS_MEMBER_PERSON I, PS_MEMBER_PHONE J
WHERE I.SUPPORT_TEAM_MBR = J.SUPPORT_TEAM_MBR(+)
Any suggestions?
I have tried writing an expression with the field that I need but it dosn't pass edit because the field is not listed in the query. I can successfully run it in my SQL editor. Here is the SQL that I wish to run.
SELECT PHONE FROM PS_MEMBER_PERSON I, PS_MEMBER_PHONE J
WHERE I.SUPPORT_TEAM_MBR = J.SUPPORT_TEAM_MBR(+)
Any suggestions?