Database view Where Clauses

[Wendy20]

Hi all,

I have created the below database view and need some help with the where clauses.  The requirement is to view all security incidents Opened by "x" .  It should contain information on the user that is assigned to this incident.  and also should include Task SLA details for the security incident.  No records are showing.  

If I use the where clause for Task SLA as "tsla_sla"  and I can see records but it's showing millions of records where only less then 1000 security incidents were opened by "x" user.  Any advice will be appreciated. Thank you!

[Wendy20 · Accepted solution]

Thanks for your help. I used your suggestion and modified a bit and it's working.  See below.  Really appreciate your help.