> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 17, 2003 8:12 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Issues with count(), aliases, and LEFT JOINS
>
> Try changing it to this:
>
> ...
> -> COUNT(DISTI
Original Message-
From: Brandon Ewing [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 1:59 AM
To: [EMAIL PROTECTED]
Subject: RE: Issues with count(), aliases, and LEFT JOINS
> -Original Message-
> From: Brandon Ewing [mailto:[EMAIL PROTECTED]
> Sent: Monday, Dec
> -Original Message-
> From: Brandon Ewing [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 2:28 AM
> To: [EMAIL PROTECTED]
> Subject: Issues with count(), aliases, and LEFT JOINS
>
> Greetings,
>
> This is driving me crazy.
>
> I'm ru
Greetings,
This is driving me crazy.
I'm running MySQL 4.0.15-standard.
I've got a db that tracks switches, servers they connect to, and connections
between switches.
Schema for server:
+--+
--+
| Field|