I think I should be able to claim SQL as a second language - you can say so
much with it!
Brandon Ewing
-Original Message-
From: Dominique Plante [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 4:43 PM
To: 'Brandon Ewing'
Subject: RE: Need help with a SELECT statement acro
we have to take each update_id, compare
the update OS against a server entry OS, and decide if it matches, then
check the server_update table to see if the update is applied already. I
imagine that it would be sorted by server_id, then update_id.
Has anyone done anything similar before, and can h
> -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(DISTINCT switch_connect1.switch_id) AS lef
> -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
|24 | 0 |0 |
| 8 | 5 |24 | 0 |0 |
+---+-+---+-+--+
I've been pounding my head against this for a while now - can anyone offer
any illumination as to what exactly I'm screwing up?
I'd prefer not to do any major schema re-
