he-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 22, 2007 3:30 PM
> To: Jerry Schwartz
> Cc: 'MySQL General'
> Subject: Re: Left join is not doing what I thought it sho
n, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Critters [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 22, 2007 12:23 PM
To: MySQL General
Subject: Left join is not doing what I thought it shou
mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 22, 2007 12:23 PM
> To: MySQL General
> Subject: Left join is not doing what I thought it should do.
>
> I have 3 tables
> A users table (userID, userName)
> A leaderboard table (userID, score)
> A friends table (userIDA, us
I have 3 tables
A users table (userID, userName)
A leaderboard table (userID, score)
A friends table (userIDA, userIDB)
I would like to produce the following result:
userName, score, userIDA
Dave, 100, 1
Simon, 200, 5
Paul, 300, NULL
The 3rd record is NULL as there is no record in "friends" wit