Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Report of Colleagues Personal Email Addresses
Content
Hello,
Please could someone help.
I am trying to build a report to return all employees and their personal email addresses - for those that dont have personal email addresses and/or email type "Home Email", it should bring up their details but blank in the home email column. I am not keen on using logical sql but i was told that Union query (which i am also unfamiliar with) could work for this. i have tried the minus union query [(all employees) minus union (employees with home email type)] to get employees that dont have home email addresses and what i got was details of employees that
Tagged:
1