query across many-to-many

[Brian Craft]

How do you do a query across a many-to-many relationship? E.g. if you have

(defentity pizza (many-to-many toppings))

(defentity toppings (many-to-many pizza))

and you want all the toppings for pizza #12, something like

(select toppings (where { :pizza.id 12}))

This generates sql like

"select toppings.* from toppings where pizza.id = 12"

which doesn't work, obviously.