IF the dates are limited and can be agreed upon before running the
kwiri, you can use:
SELECT no,
IF (date=d1, data, NULL) d1,
IF (date=d2, data, NULL) d2,
IF (date=d3, data, NULL) d3
FROM table
GROUP BY no;
It will also NOT work if one date can contain multiple data,
On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote:
Hi there. I am a rank amateur at this trying to make sense out of a heap (and
growing) of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljh
Phil Evans [EMAIL PROTECTED] wrote:
Hi there. I am a rank amateur at this trying to make sense out of a heap (and
growing) of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljhd2
2asdd3
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list