On 2013-01-03 13:04, Frédéric wrote: > On dimanche 30 décembre 2012, sxpert wrote:
>
>> le secret est dans le "distinct on (on_evt.ts)" ;-)
>
> Qui n'a pas l'air de marcher avec MySQL :o(
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL
> server version for the right syntax to use near 'on (on_evt.ts) *
> from on_evt, (select * from
> off_evt) as off_evt where on_evt.ts' at line 1