TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
Bidzina Goginashvili
NA
206
26.2k
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