Need to create Database View for merging two table LEFT OUTER JOIN

[ahmadfaiz]

I have two tables Story table(rm_story) and Change Request table(change_request).

to combine two table we have story.sys_id  = change_request.parent

Requirement is we need to show all the story when it has change request added or not. 

So that customer can we all the stories in that table and can check what are change request and what are all the Change task in that table.

[Brad Bowman]

Can you see these stories in a list view?  This is a simple Database View example, and this is the expressed purpose of the Left join field.  It works fine for me in my PDI