2021-07-20

主副表关系为一对多时，左链接查询只取每组一对多中的一条记录（id最大的）的sql语句：

String sql =“SELECT a.*, c.card_owner card_owner, c.card_num card_num FROM agent_user_new a LEFT JOIN (select MAX(id), agent_user_id, state, card_owner, card_num FROM agent_user_card_new GROUP BY agent_user_id) c ON a.id = c.agent_user_id”;