Many-to-Many relationship issue (ALL subquery?)

Basic layout

Resource
IdResource
Name

Keyword
IdKeyword
Name

There is a many-to-many association table connecting the two.

Problem:
The keywords are used as filters. A user can select any number of keywords and it should filter the results such that each resource has ALL of the keywords selected associated (and any others not selected - the important point is that all that are selected are associated).

I can implement in PHP manipulating arrays ... but that's really slow when dealing with thousands of resources.

I essentially want to do:
QQ::In_All(QQN::Resource()->Keyword->Keyword->IdKeyword, $arrSelectedKeywords) ... something like an SQL subquery with the ALL operator such that it will “return TRUE if the comparison is TRUE for ALL of the values in the column that the subquery returns.”

Any ideas? It's probably really simple - I'm just a bit perplexed.

Thanks,
Andrew

Cool deals -- if you check out Issue #42 you'll see we're starting to get some traction on some improvements to the QQ layer.  Once the current dev release cycle gets pushed to stable I'm pretty sure these movements will start accelerating a bit.

It looks like you and folks at qcubed have thought through some stuff as well, I'd love any input (either higher level suggestions or even lower level code contributions, if you have them) that you'd be willing to provide.

Thanks!  Yeah, it probably makes sense to get this in, along with a lot of the other QQ changes that have been discussed, right after we get the next stable out, which should hopefully be 0.4.14 within the next day or so.