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.