The distinct is needed for usersonline as it holds multiple instanses of the user's name, which I only want once.
To answer your question the user name comes up many times and the 1 still exist in ever record of the returned results, which of course is not true. ---------- Original Message ----------- From: gerald_clark <[EMAIL PROTECTED]> To: vernon <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 11:13:53 -0500 Subject: Re: SQL query - 3 tables - 3rd one conatins records to not display > And what happens if you leave off the 'distinct' ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
