Database View - Viewing Related Lists under a Change Request

[Patrick Rodrigu]

Hello, 

I'm trying to create a database view to show related items under a change request (for reporting purposes) 

Below is what I've created so far: 

What am I missing?

Thank you for any help/guidance!

[Jaspal Singh · Accepted solution]

That is because all the above Where Clause conditions are taken as AND & not OR

[Patrick Rodrigu]

Can you explain a little further for me?

[Jaspal Singh]

I mean when you try above it will look for  a change request that has Problem, RITM, Incidnet all associated to a particular change reqeust. 

In case, if a change has only problem then it will not show up as the above will be an AND for all the Where clauses.

[Patrick Rodrigu]

Ah OK that makes sense. So for the problem table what could I change the Where Clause to?