How do I query on object 'c' when I have an Id from 'a' and and Id from 'b' as lookups in 'c'? I need to return the exact record in c that has both fields in 'a' and 'b'.
Query on both lists does not work because it would miss values. Do I need to use a wrapper to get both Ids as a key value pair? OR some kind of AR query?
List<objectC> listC = [SELECT Id FROM objectC WHERE Id IN listB AND Id IN ListA];
Maybe there is another way to build a map using key value pairs or some other type that I could prepare a new list on to query exactly what I want. Not sure.