Re: EXTERN JOIN with WHEN query

On Thu, 5 Jun 2003 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"

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