select espclo_ouverture.*, espclo_ouverture_local.desclocal, espclo_ouverture_type.descforme from {oj espclo_ouverture left outer join espclo_ouverture_local on espclo_ouverture.idlocal = espclo_ouverture_local.idlocal left outer join espclo_ouverture_type on espclo_ouverture.idforme = espclo_ouverture_type.idforme} where espclo_ouverture.idespclo = 32 order by espclo_ouverture.noouvertThat query actually runs fine, but I don't understand what the
{oj
does! I wrote that query but I don't remember putting that there. If I remove just the "oj", leaving the curly braces I get "Syntax error or access violation". It can't be just a typo because the curly braces close just before the WHERE clause. If I remove all that (plus the closing brace), the query still runs fine, as I expected.