select C.CompanyName ,C.CompanyID,R.URLPart,C.Photo,T.ReportID from dbo.KALKINE_Company C inner join dbo.KALKINE_ReportsCompanyTag T on C.CompanyID = T.CompanyID inner join dbo.KALKINE_Reports R on R.CompanyID = T.CompanyID where T.ReportID = 855
SELECT DISTINCT companyName, CompanyId, URLPart FROM ...
SELECT DISTINCT C.CompanyName ,C.CompanyID,R.URLPart,C.Photo,T.ReportID FROM dbo.KALKINE_Company C WHERE T.ReportID = 855
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)