how to select distinct product name with inner join

Question

how to show distinct tagname from this query ===================================== select distinct TagName *CEILING(Price/@priceindollar)as dollar(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

Khan Abrar Ahmed · Answer

HI u r using a *  this will select all you column if u want to use distinct value specify the column names.

Devendra Kumar · Answer

how to use this query in main query: select distinct TagName(REPLACE(TagName' ''-')) as SeoProduct_Name from dbo.tbl_Image_Master this given out put like this: