List:General Discussion« Previous MessageNext Message »
From:John Meyer Date:September 11 2009 12:59am
Subject:Re: Natural join problem
View as plain text  
Thanks.  That worked.

Jason Trebilcock wrote:
> Methinx you need a "GROUP BY" in there.  See below.
>
>   
>> -----Original Message-----
>> From: John Meyer [mailto:john.l.meyer@stripped]
>> Sent: Thursday, September 10, 2009 6:48 PM
>> To: mysql@stripped
>> Subject: Natural join problem
>>
>> 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;
>>
>>     
>
> select u.user_name, count(t.tweet_id)
> from users u, tweets t
> where u.user_id = t.user_id
> group by u.user_name
>
>
>   

Thread
Natural join problemJohn Meyer11 Sep
  • RE: Natural join problemJason Trebilcock11 Sep
    • Re: Natural join problemJohn Meyer11 Sep