:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 17:32
To: MySQL List
Subject: grouping / sorting etc..
Im having troubles getting the results I want... can someone suggest
which way to go..
mysql 4.0
A
| 1 | |
| 1 | BAD |
| 2 | |
| 3 | BAD |
| 3 | |
| 4 | BAD |
| 5
Hello Christopher,
Friday, July 11, 2003, 6:31:33 PM, you wrote:
First select:
The results are just right what you want in your SELECT.
You have 5 different values in COLUMN1 and your select returns them.
From second column SELECT gets first value for each value of first
column.
Second select:
:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 17:32
To: MySQL List
Subject: grouping / sorting etc..
Im having troubles getting the results I want... can someone suggest
which way to go..
mysql 4.0
A
| 1 | |
| 1 | BAD |
| 2 | |
| 3 | BAD |
| 3 | |
| 4 | BAD |
| 5
Im having troubles getting the results I want... can someone suggest which way to go..
mysql 4.0
A
| 1 | |
| 1 | BAD |
| 2 | |
| 3 | BAD |
| 3 | |
| 4 | BAD |
| 5 | |
| 5 | BAD |
| 5 | BAD |
what I want is 5 results. If there is a NULL, then