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, e.g.
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
"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
> 2
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
>
