Ticket with state different to closed not appear in my database view

[mregragui_ext]

Hello community,

I have create a database view between 3 tables to have all the tickets with all the states append to survey result but i am just getting tickets that in state closed or closed complete.

here is the database that i made 

[Brad Bowman]

In my PDI I also had to make 300 Left join = true or I was getting a syntax error on ai_sys_id when clicking the Try It Related Link.  That gives me a bunch of records, some with an empty ai Number, and empty aiq Instance.  Are you still getting 0 records with the ai Number field (empty) even with a left join = true on 200?

[mregragui_ext]

hi @Brad Bowman  ,

with left join on 200 i got this database error 

[Brad Bowman]

That reflects the condition I described above.  Did you also add a left join to 300?