left join on in

mysql中left join on后面一般来说是 a=b

最近，同事写了个语句是

" left join school_campus as campus on campus.camId in payment.secondPayCamId,payment.firstPayCamId) "

转载于:https://blog.51cto.com/wangyuelucky/888404