Access second table data using SQL Join

Question

I have two tables, Members and GroupMembers. I FullName from Members and MemberID from GroupMembers , but I don't know how to modify this query to achieve that:

SELECT FullName
FROM Members
INNER JOIN GroupMembers ON Members.ID=GroupMembers.MemberID
WHERE GroupMembers.GroupID = 'foo'

It gives Members.FullName, but also I need GroupMembers.ID on Members.ID=GroupMembers.MemberID

marc_s · Accepted Answer · 2012-07-22 14:15:07Z

1

Just add that second column to your SELECT statement:

SELECT 
    m.FullName, gm.ID
FROM 
    Members m
INNER JOIN 
    GroupMembers gm ON m.ID = gm.MemberID
WHERE 
    gm.GroupID = 'foo'

Once you've created this join between the two tables, all columns from both tables are available to be selected, if need be.

I've also chosen to use table aliases in this SELECT statement - while it's not necessarily needed, I believe it makes things a lot more readable and clearer.

answered Jul 22, 2012 at 14:15

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Withers · Accepted Answer · 2012-07-22 14:15:39Z

1

SELECT Members.FullName, GroupMembers.ID
FROM Members
INNER JOIN GroupMembers ON Members.ID=GroupMembers.MemberID
WHERE GroupMembers.GroupID = 'foo'

answered Jul 22, 2012 at 14:15

Tim Withers

12.1k5 gold badges45 silver badges68 bronze badges

Collectives™ on Stack Overflow

Access second table data using SQL Join

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related