RE: Natural join problem

2009-09-10 Thread Jason Trebilcock
Methinx you need a GROUP BY in there. See below. -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Thursday, September 10, 2009 6:48 PM To: mysql@lists.mysql.com Subject: Natural join problem Two tables: USERS: USER_ID (PK) . . .etc TWEETS:

Re: Natural join problem

2009-09-10 Thread John Meyer
Thanks. That worked. Jason Trebilcock wrote: Methinx you need a GROUP BY in there. See below. -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Thursday, September 10, 2009 6:48 PM To: mysql@lists.mysql.com Subject: Natural join problem Two tables: