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)
原创
2021-07-20 17:23:27 ·
55 阅读 ·
0 评论