Joining 3 tables and it is duplicating

Bidzina Goginashvili

7y1.1kSQL

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

6 Replies

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

Amit Kumar7y ago
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.
0
Jignesh Kumar7y ago
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
0
Shweta Lodha7y ago
Hi Bidzina,
Did any of our suggestions work for you? If not, please share the data of all the tables with us.
0
Kapil Singh Kumawat7y ago
You can use GROUP BY clause.
0
Rajanikant Hawaldar7y ago
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
0
Shweta Lodha7y ago
You can update your query by using distinct keyword. for example,
Select distinct gr.Name as...
+1