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.
My desired result would be:
Email | GROUP_NAME
Email1@yahoo.com | Membership1
Email1@yahoo.com | Membership2
Email2@yahoo.com | Membership2
Email3@yahoo.com | Membership1
Email3@yahoo.com | Membership2
Any idea how to join these two together?