请教一个SQL语句 不要重复记录

[xiahouwen]

img_info.col_img_name这个字段有重复的记录
我不想要其他img_info.col_img_name重复的记录


select distinct img_group.col_group_name,
img_info.col_img_id,
img_info.col_img_hits,
img_info.col_img_dir,
img_info.col_img_name
from img_group join img_info
where
img_group.col_group_id=1
and
img_info.col_img_group=1

[xinyaoxp]

select distinct
img_group.col_group_name,
img_info.col_img_id,
img_info.col_img_hits,
img_info.col_img_dir,
img_info.col_img_name
from img_group join img_info group by img_info.col_img_name;

[活靶子哥哥]

美有用 我要的