CODE EXAMPLE FOR SQL

Linq Join

Easy...

List<PropX> first;
List<PropA> second;
var query = from firstItem in first
    join secondItem in second
    on firstItem.b equals secondItem.b
    select firstItem;