select distinct value with all column

Question

please solve this query  i want show all fields from  tbl_Image_Master but tagname show but not repeat 

i.e distinct tagname 

 

 

select distinct TagName as new, *,(REPLACE(TagName,' ','-')) as SeoProduct_Name from dbo.tbl_Image_Master inner join dbo.tbl_size on tbl_size.Size_Id=tbl_Image_Master.Size_Id inner join tbl_category on tbl_category.Cat_Id = tbl_Image_Master.Cat_Id