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

    Basic SQL Help


      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\"


      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