sql query for duplicate records

Question

Hello Sir I am stuck with a problem Here is master(Tble_MainData) table contain company name brand name item name. But I want list of MasterIDcompanyidbrandiditemid as same shown in the matertable's each record instead of names using select query that below mentioned ' (if there is mistake in select query please current it) and also i have attached herewith 4 tables with data script. select distinct(Tble_MainData.ID)ProductCompany.Id as CompanyIDBrands.Id as BrandID Items.Id as ItemID from Tble_MainData inner join Brands on Tble_MainData.Brand = Brands.BrandName inner join Items on Tble_MainData.Item = Items.ItemName inner join ProductCompany on Tble_MainData.Company = ProductCompany.CompanyName Kindly replay me. Thanks.

Francis · Answer

Try this script it will return id instead of its name: select main.IDcompany.Id as companyidbrand.Id as brandiditem.Id as itemid from Tble_MainDatamain inner join ProductCompanycompany on main.Company=company.CompanyName inner join Brandsbrand on company.Id=brand.ProductCompanyId and main.Brand=brand.BrandName inner join Itemsitem on company.Id=Item.ProductCompanyId AND main.Item=item.ItemName and item.BrandsId=brand.Id

Francis · Answer

Sorry for the inconvenience. I'munable to see your script. Since I can'tdownloadnow in my work place.What the exact result you want to achieve and whatyour query returns now?

Mani Kandan · Answer

Francis Sir I have a master table contain company name brand name item name only. And those are have each independent tables that is Tble_company (companyidcompantname)Tble_brand(brandidbrandname)Tble_items(itemiditemname). But I want a select query for list of those ids (ie = masteridcompanyidbrandiditemid) as same as see how the master tables each record seen instead of those names. Please download and check then answer me sir.