Difference between writing multiple filter and a single in aggregates.

Difference between writing multiple filter and a single in aggregates.

  

I want to write WHERE clause in 3 different entities in aggregate. So we have 2 choices like below:


We can write 3 conditions by adding 3 filters and can write 3 conditions in a single filter.
So, Is these both ways are correct? 


I doubt, Because these conditions are with 3 different entities, kindly suggest.

Solution

Both are correct

Solution

In this case, both are correct yes.

It's more that you want to create complex filters with "or" you probably and up doing that in one filter.