sql 两表left join查左表最大一条记录
select * from A left join B on A.id=B.cid and B.adddate =(select max(adddate) from tableB where cid=B.cid)
向大家推荐《Activiti工作流实战教程》:https://xiaozhuanlan.com/activiti
sql 两表left join查左表最大一条记录
select * from A left join B on A.id=B.cid and B.adddate =(select max(adddate) from tableB where cid=B.cid)
有建议,请留言!