distinct完有个字段是不需要distinct的、但是有需要展示--直接找到你需要distinct的字段用group by 解决了
SELECT DISTINCT
t1.mapping_id,
t1.mapping_type,
t1.mapping_tab,
t1.mapping_name,
t2.crt_team
FROM
ty_etl.version_mapping t1
LEFT JOIN ty_etl.version_manage t2 ON t1.mapping_id = t2.mapping_id
WHERE
t1.mapping_type = 'datasource'
Group By t1.mapping_id
如果Group By t1.mapping_id没有的话 mapping_id会有很多重复的