I lightly boiled my head, perhaps a simple task, but to mind nothing comes.
We have Many X, for example (1,2; 2,3,4; 7,9,1; 1,0), there are a number of Y, as in (1,2,3,4,5,6,7,8)
Is it possible to show X only what is fully present in Y? In the sample only (1,2; 2,3,4).
If simply making the same IN design, but not for each member (1 is in Y, then satisfies the condition), and across collections.
SELECT t1.id FROM table1 t1, table2 t2 WHERE t2.key NOT FULLY IN(SELECT id FROM table3)