How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?
Summary:
I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have a matching Task_id in Comment table. How to join with these two tables so i am not dropping anything from Comment table. I have tried outer join on fnd_bpm_task_comment but it doesn't work.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
0