SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Join two table functions together

rgiljohannJun 6 2022

Hello, I am brand new to Oracle. I have two table functions that work, but I am trying to join the resulting records together.
1st Table Function:
SELECT Email FROM TABLE((idcs_client.user_profiles));
Results in:
Email as column
Email1@yahoo.com
Email2@yahoo.com
Email3@yahoo.com

2nd Table Function:
Select * From Table(idcs_client.get_user_membership1('Email1@yahoo.com'));
Results In:
GROUP_NAME as column
Membership1
Membership2

I am trying to join these together so I can get all the GROUP_NAMES from the 2nd table function for each email address in the first table function. The 2nd table function requires me to enter the email address in the parameter.

Any idea how to join these two together?

Added on Jun 6 2022

#sql-developer

6 comments

845 views