Joining 3 tables and it is duplicating

Question

SELECT gr.Name as GroupName,gr.Id as GroupId FROM SpecificationAttribute sa INNER JOIN SpecificationGroup gr on SpecAtr.GroupId = gr.Id left JOIN CategoryAttribute as cat on cat.SpecificationAttributeId = SpecAtr.Id the rows are duplicating so gr.Id is prymary key SpecAtr.Id is primary and cat.SpecificationAttributeId is foreignkey pleas help me

Jignesh Kumar · Answer

Hi, you can use distinct in your select statement and group by your groupId SELECT distinct gr. Name as GroupName,gr.Id as GroupId FROM SpecificationAttribute sa INNER JOIN SpecificationGroup gr on SpecAtr.GroupId = gr.Id left JOIN CategoryAttribute as cat on cat.SpecificationAttributeId = SpecAtr.Id group by gr.Id

Kapil Singh Kumawat · Answer

You can use GROUP BY clause.

Shweta Lodha · Answer

You can update your query by using distinct keyword. for example, Select distinct gr.Name as...

Amit Kumar · Answer

Hi, Your query is perfect you can do one thing use distinct before gr.Name like distinct gr.Name it will work fine. I hope it will help you.

Shweta Lodha · Answer

Hi Bidzina, Did any of our suggestions work for you? If not, please share the data of all the tables with us.

Rajanikant Hawaldar · Answer

You should provide tables details(columns and data) of three tables to help you. using of "Distinct" will not fix your duplicate issue? SELECT Distinct gr.Name as GroupName,gr.Id as GroupId FROM SpecificationAttribute sa INNER JOIN SpecificationGroup gr on SpecAtr.GroupId = gr.Id left JOIN CategoryAttribute as cat on cat.SpecificationAttributeId = SpecAtr.Id