whenever i filter the data on my composite key. Instead of getting the union i want intersection of result.
for query(a , b) i’m getting some values. Actually i do not have any values that matches for query(a , b) but it is showing the values for query(a) on query(a,b).
I do not want the union but the intersection just as we do in sql using where clause.