renti

Problem with LEFT JOIN (ExecuteSQL)

Discussion created by renti on Apr 12, 2016
Latest reply on Apr 13, 2016 by renti

Hello,

Could someone help me out with the syntax of this Execute_SQL sentence ?

 

Let (

[query = "

select SUM (d.Horas)

FROM T02_Partes_DETALLES AS d

LEFT JOIN T02_Partes AS p

ON d.Id_detalles_parte = p.Id_parte

WHERE p.Categoria = ? AND p.Tarea = ?

" ;

query_2 = ExecuteSQL (query ; "" ; ""; "Herbicida"; "Cuba")];

query_2)

 

regards,

Outcomes