CODEWITHSUNDEEP
sql
user479947
user479947

Reputation:

SQL query for matching a column across two tables

I have two SQL tables: users & userGroup with data like:

users: 

 user      | age | gender

    testUserA,  25,   Male
    testUserB,  30,   Female
    testUserC,  35,   Male

userGroup: 

user     | group

testUserA, groupA
testUserB, groupA
testUserC, groupB

How would I phrase a query to list the male users in groupA?

Upvotes: 2

Views: 72

Answers (3)

Whodiopolis
Whodiopolis

Reputation: 11

This query would join the two tables together and also filter by gender.

SELECT u.User, u.Gender, ug.Group
FROM user u
INNER JOIN userGroup ug
ON u.user = ug.user
WHERE u.gender = 'Male'
AND ug.Group = 'groupA';

Upvotes: 0

Emacs User
Emacs User

Reputation: 1475

Here's one way to do it:

select a.user, a.age, a.gender, b.group from users as a 
inner join userGroup as b on a.user=b.user 
where a.gender='Male' and b.group='groupA'

Upvotes: 0

potashin
potashin

Reputation: 44581

All you need is a join and a where clause to filter gender and group:

select u.user
from user u
join userGroup ug on u.user = ug.user
where u.gender = 'Male'
  and ug.group = 'groupA'

Upvotes: 3

Related Questions