On Thu, Jun 05, 2003 at 16:56:54 +0200,
javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)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"
>
> Could you help me with this query?
The keyword should be "WHERE" instead of "WHEN".