This is probably trivial but i couldn't find an answer.
Let's say I have three Models
Order (order_id) OrderItems (order_id, item_id) OrderPromotion(order_id,item_id, other_fields)
Is there any way to make a relation from OrderItems to OrderPromotion
to be equivalent of select * from OrderPromotion where order_id = 11232 and item_id = 23432