On Thu, 5 Jun 2003 16:56:54 +0200, javier garcia - CEBAS
<rn001@cebas.csic.es> wrote:
>SELECT fechas.fecha,precipitacion FROM fechas LEFT OUTER JOIN precal41 ON
>(fechas.fecha = precal41.fecha) WHEN fechas.fecha >= min(precal41.fecha);
>
>With the answer:
>
>ERROR: parser: parse error at or near "WHEN"
The keyword is "WHERE". And I guess the WHERE clause has to be
WHERE fechas.fecha >= (SELECT min(fecha) FROM precal41)
or, if there is an index on precal41.fecha, more efficiently but
non-standard
WHERE fechas.fecha >= (SELECT fecha
FROM precal41 ORDER BY fecha LIMIT 1)
HTH.
Servus
Manfred