php - Yii 关系子查询

Question

这是我的查询:

select * from order_shipping_date osd inner join  
(SELECT MAX(osd.id) as id FROM  order_shipping_date osd 
group by osd.order_id) osdi ON osd.id = osdi.id 

我可以保持这样，但希望可以将其定义为 relations

这样以后使用这样的代码更舒服这到底可行吗？我找不到任何例子。

Answer 1

Additional options可以在关系声明中指定。

public function relations()
{
    return array(
        'orderShippingDate' => array(
            // define you relation
            'join' => '(/* subquery here*/) osdi ON osdi.id=orderShippingDate.id',
            'joinType' => 'INNER JOIN'
        ),
    );
}