AnsweredAssumed Answered

Basic SQL Help

Question asked by dcp3 on Jul 27, 2017
Latest reply on Jan 29, 2019 by fmpdude

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



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


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