SQL语句，查询两张表多条字段，出现重复项如何去掉重复数！

SQL语句：select A.CXM,A.CXB,A.CNL,B.CZDMC,B.DZDSJ FROM YXHIS2020..TBMZGHMX202001 A , YSGZZ2020..VTBMZBLZDXX2020 B WHERE B.CMZH=A.CMZH and B.czdmc like'%腹泻%'
查询出多条重复数据，想问如何去掉重复的数据？

select DISTINCT(A.CXM) CXM,A.CXB,A.CNL,B.CZDMC,B.DZDSJ FROM YXHIS2020..TBMZGHMX202001 A , YSGZZ2020..VTBMZBLZDXX2020 B WHERE B.CMZH=A.CMZH and B.czdmc like'%腹泻%';
如有帮助,欢迎采纳!

select DISTINCT A.CXM,A.CXB,A.CNL,B.CZDMC,B.DZDSJ FROM YXHIS2020.TBMZGHMX202001 A , YSGZZ2020.VTBMZBLZDXX2020 B WHERE B.CMZH=A.CMZH and B.czdmc like'%腹泻%'