For example:

```
pk_ref    fk
======    ===
1         a
1         b
1         c
2         a
2         b
2         d

```

How do I do a query like the "pseudo" query:

```
select distinc pk_ref
where fk in all('a', 'c');

```

The return query result must match all given values for the foreign key in the list.

The result should be:

```
1

```

While the following select must not return any records.

```
select distinc pk_ref
where fk in all('a', 'c', 'd');

```

How do I do that?