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 = '450783' order by InternetTypecode,companyname
Material Testing Machines, Hardness Testing Machines, Vickers Hardness Testing Machines, Brinell Testing Machines, Rockwell Hardness Testers, Dynamic Hardness Testers, Universal Testing Machines, Educational Equipments, Impact Testers
India Yellow Pages, Indian Industrial Yellow Pages, Indian Manufacturers online Guide
Material Testing Machines, Hardness Testing Machines, Vickers Hardness Testing Machines, Brinell Testing Machines, Rockwell Hardness Testers, Dynamic Hardness Testers, Universal Testing Machines, Educational Equipments, Impact Testers, Business Directory, India Yellow Pages, Indian Industrial Yellow Pages, Industrial Directory, Industrial Directory, Indian Manufacturers online Guide
