List:General Discussion« Previous MessageNext Message »
From:John Meyer Date:September 10 2009 11:47pm
Subject:Natural join problem
View as plain text  
Two tables:

USERS:
USER_ID (PK)
. . .etc

TWEETS:
TWEET_ID (PK)
USER_ID (FK)

Trying to get the user information and the number of tweets each person has:

SELECT USERS.USER_NAME, COUNT(TWEETS.TWEET_ID) AS 'TWEETCOUNT' FROM 
TWEETS NATURAL JOIN USERS;

But it seems to be just rolling up all the information into one row.
Thread
Natural join problemJohn Meyer11 Sep
  • RE: Natural join problemJason Trebilcock11 Sep
    • Re: Natural join problemJohn Meyer11 Sep