| 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 problem | John Meyer | 11 Sep |
| • RE: Natural join problem | Jason Trebilcock | 11 Sep |
| • Re: Natural join problem | John Meyer | 11 Sep |
