摘要：表Aid name1aaaa2 bbbb3 cccc表Bid A_id log1 1132221131132 13334 3 1355表A为人员信息表，表B为信息日志表。要求列出人员最后日志状态SELECT A.id, A.name, B.logFORM A INNER JOINB ON A.id=B.A_id AND B.id=(SELECT MAX(id) FORM B WHERE A_id=A.id)ORDER BY A.id DESC 阅读全文