mybatis3,在写sql的时候把or的几个条件用()包起来(因为and比or优先级高,所以会在查完所有and条件之后才会进行or,如下
SELECT B.* FROM order_basic a INNER JOIN order_combo b WHERE (a.consignee_mobile = 15201576119 OR a.buyer_mobile = 15201576119) AND a.payment_status = 2 AND a.order_code = b.order_code)
在mybatis中这样,我写的是2表联查(跟多表联查没什么关系),