8 Replies Latest reply on Apr 13, 2016 7:22 AM by renti

    Problem with LEFT JOIN (ExecuteSQL)

    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,