While select table1 where table1.itemid == table2.itemid && table2.feature == A && table2.feature == B && table2.feature == C { }