Re: Verifying Ownership on INSERT for Many-to-Many

[Peter Brawley]

Perhaps something like ...

SELECT ic.itm_id
FROM users u
INNER JOIN items AS i USING (acc_id)
INNER JOIN item_categories AS ic USING (itm_id)
INNER JOIN categories AS c USING (cat_id)
WHERE u.acc_id=<current user's account id)
AND c.cat_id=<desired category>

PB