Devendra  Kumar

Devendra Kumar

  • NA
  • 517
  • 246k

how to select distinct product name with inner join

Apr 8 2016 2:24 AM
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

Answers (2)