$model = M ()->table ( 'zj_loan_order o' )->join ( 'zj_loan_bill b on b.order_id = o.id and b.issue = o.last_bill_issue' );
$model->join ( 'zj_loan_bill_dun d on d.order_id=b.order_id', 'left' );
$model->join ( 'zj_university_campus c on c.id=o.campus_id', 'left' );
$model->join ( 'zj_loan_user_contract u on u.uid = o.uid' )->where ( $conditions );
$data = $model->field ( '
o.id,
o.title,
o.money,
o.first_money,
c.city city_name,
b.issue,
b.money_fee,
b.money_delay,
b.money_total,
b.return_money,
b.return_limit_time,
d.created created,
d.content content,
u.*' )->select ();
在第二条 SQL 我想只查最后一条 结果我用
$model->join ( 'zj_loan_bill_dun d on d.order_id=b.order_id', 'left' )->order("d.created desc")->limit(1); 这样查是查不到的 , 求指导!