Database views with left join Approval-RITM-SCTask

[olufsen]

Hi, I am starting to learn database views and left join hence I need help from the experts.

I have created this and it is working fine except that if a RITM has pending approval, no SCTask is generated yet but I wanted to display the RITM on the report with empty task. 

How am I going to implement that?

[James Chun · Accepted solution]

Hi @olufsen,

Try this, you will need to adjust the order and use left join:

e.g.

Cheers

[olufsen]

Order works. Thank you so much!!