Database view problems on "Try It"

[MARISA INACIO1]

Hi everyone,

I create this database view where the "u_m2m_test_defects" is a custom table to connect "sn_test_management_test" to "rm_defect". 

This works in my personal development instance, but in the client instance didn't work, Someone have an idea why? Was built the same way in the two instances.

Thanks in advance,

Marisa

[SumanthDosapati]

@MARISA INACIO1 

If it works in PDI, it should work in other instance also ideally.

So,

1. check if any mistakes in where clause and if the fields exists.
2. check if the data is good correct in all the tables.

Regards,
Sumanth