1 2 Previous Next 22 Replies Latest reply on Jul 27, 2017 3:47 PM by beverly

    Basic SQL Help

    dcp3

      Newb to SQL looking to accomplish something i have yet to do. I am looking to get the timestampfinished of a task being completed in the release_ORDERPHASETASK table and put that value onto the RELEASE table. I am only looking for the finish date of the related task by _OrderID and where the task number is 2.16

       

      Below is what i have, however it returns that this there are too few parameters in this function.

       

      ExecuteSQL (" SELECT \"TimestampFinished\"

      FROM \"ORDERPHASETASK\" JOIN \"RELEASE\"

      ON \"ORDERPHASETASK._OrderID\" = \"RELEASE._OrderID\"

      WHERE \"ORDERPHASETASK.tasknumberlu\" = '2.16'")

       

      Any help to see what i am missing would be great.

        1 2 Previous Next