Select a.CompanyID,CompanyName,ContactPerson,Add1,Add2,Add3,a.Pincode,TelSTDCODE,TelNo,FaxSTDCODE,FaxNo,Email,PartyEmail,Website,PartyWebsite,FreeEntry,Activities,b.ProductID,ProductName, c.GroupID, GroupName, InternetTypeCode,DistrictName from mstCompany a left join trnCompanyProd b left join mstProduct c left join mstGroup e on c.GroupID=e.GroupID on b.productid=c.productid on a.CompanyID=b.CompanyID left join mstDistrict d on a.DistrictID=d.DistrictID where a.CompanyId = '252535' order by InternetTypecode,companyname
Universal Testing Machines, Hardness Testing Machinery, Material Testing Machines, Hardness Test Blocks, Diamond Indentor, Steel Ball Indentor, Tungsten Carbide Ball, Portable Hand Held Tester, Poratble Brinell Bar Hardness Tester & Poldi hardness Tester, Jominy Fixtures
India Yellow Pages, Indian Industrial Yellow Pages, Indian Manufacturers online Guide
Universal Testing Machines, Hardness Testing Machinery, Material Testing Machines, Hardness Test Blocks, Diamond Indentor, Steel Ball Indentor, Tungsten Carbide Ball, Portable Hand Held Tester, Poratble Brinell Bar Hardness Tester & Poldi hardness Tester, Jominy Fixtures, Business Directory, India Yellow Pages, Indian Industrial Yellow Pages, Industrial Directory, Industrial Directory, Indian Manufacturers online Guide