sql query for duplicate records

Abhilash J A

10y1.1kSQL

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 MasterID,companyid,brandid,itemid 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 CompanyID,Brands.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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
Accepted answer
Try this script, it will return id instead of its name:
selectmain.ID,company.Idascompanyid,brand.Idasbrandid,item.Idasitemid
fromTble_MainDatamain
innerjoinProductCompanycompanyonmain.Company=company.CompanyName
innerjoinBrandsbrandoncompany.Id=brand.ProductCompanyIdandmain.Brand=brand.BrandName
innerjoinItemsitemoncompany.Id=Item.ProductCompanyIdANDmain.Item=item.ItemNameanditem.BrandsId=brand.Id
+1
Abhilash J A10y ago
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 (companyid,compantname),Tble_brand(brandid,brandname),Tble_items(itemid,itemname).
But I want a select query for list of those ids (ie = masterid,companyid,brandid,itemid) as same as see how the master tables each record seen instead of those names. Please download and check then answer me sir.
0
Francis Susaimichael10y ago
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?
+1