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:
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: