<?xml version="1.0" encoding="UTF-8"?> //调用resultMap //不用tesultTyp属性 select p.*,c.code from tb_person as p,tb_card as c where p.card_id=c.card_id and p.person_id=${person_id} //主键表: //关联表: 多对多: <?xml version="1.0" encoding="UTF-8"?> select o.*,p.product_id,p.name,p.price from tb_orders as o,tb_product as p,tb_ordersitem as oti where o.order_id=oti.orders_id and oti.product_id=p.product_id and p.product_id=#{product_id}