AnsweredAssumed Answered

Basic SQL Help

Question asked by dcp3 on Jul 27, 2017
Latest reply on Jul 27, 2017 by beverly

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.

Outcomes