->alias('mc.id,mc.')
->join(['dt_seller' => 's'],'mc.seller_id = s.id')
->join(['dt_seller_coupon' => 'sc'],'mc.coupon_id = sc.id')
->where(['mc.member_id'=>$this->memberId,'sc.is_deleted' => 0,'sc.status' => 0])
->whereBetweenTimeField('sc.start_time','sc.end_time')
->field('mc.id,mc.seller_id,mc.coupon_id')
->page($page)
->limit(5)
->select();
SQLSTATE[42S02]: ba
一直在报第二张表不存在 leftJoin也是同样的情况
最佳答案
