记录多表连接根据字段去重查询

Select * from (Select max(不重复的字段就行) as roleid,要去重复字段名 From 数据表 Where  条件 Group by   要去重复字段名) as A join 数据库表 on 条件

<select id="getPlanPage" resultType="com.chinamobile.cmss.zdhcspt.zdhcsptExecute.pojo.test.planEntity">
        SELECT
            p.id,
            p.name,
            p.type,
            p.isDeleted,
            p.createTime,
            p.createBy,
            p.createId,
            p.updateBy,
            p.ownProject,
            p.remark,
            p.departid,
            p.productid,
            p.productName,
            p.version,
            p.departName,
            p.isTask,
            p.cron,
            p.taskParameterId,
            p.emails,
            p.isJira,
            p.poolId,
            p.poolName,
            p.collectionId,
            p.collectionName,
            p.isTestDomain,
            p.browsers,
            p.groupId,
            p.groupName,
            p.secondCollectionId,
            p.taskSecondParameterId,
            p.secondCollectionName,
            A.updateTime AS updateTime
        FROM
        ( SELECT max( createDate ) AS updateTime, planid FROM tb_executeinfo GROUP BY planid ) AS A
        RIGHT JOIN plan p ON p.id = A.planid
        <if test="ew.emptyOfWhere == false">
            ${ew.customSqlSegment}
        </if>
    </select>