New to using JOINS, having issue

[ntroycondo]

I have a DB for videos.

I want to see what group has the most video contributors.

Here are my three tables:

1- Group and groupID

2 - Photographer, photographerID, name, and groupid.

 

I think I can use NATURAL JOIN since groupID is in both table.

I am using SUM to count but whatever statement i run returns empty or Null.

 

 

 

 

 

 

[shlumph]

I'm assuming that Group and Photographer are fields in your table, and not the table names. You'll have something similar to this:

SELECT g.Group, COUNT(p.photographerID) AS group_count FROM photo_table p
INNER JOIN group_table g ON p.groupid = g.groupID
GROUP BY g.groupID
ORDER BY group_count DESC
LIMIT 1

[ntroycondo]

Thanks for the direction So I think I got it to work with:

SELECT Group.name, COUNT(Photographer.groupid)

FROM Photographer, Group

WHERE Photographer.groupid = Group.groupid

GROUP BY Group.groupid;