Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Bidzina Goginashvili
2k
206
22k
Joining 3 tables and it is duplicating
Apr 15 2019 5:16 PM
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
Reply
Answers (
6
)
how to get opening and closing balance using MS Access Sql ?
how to count 2 SQL queries in 1 query