You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
-
So, I mean... This works :
PARAMETERS SpecifiedRecordID Long;
UPDATE tblRecords R
SET R.LockID =...
-
I could but I figured a simple JOIN on an existing (fast) query would be a lot easier? Evidently not?
-
I don't update the Outstanding field. I update a field specific to the tblRecords table based on the number of outstanding items against...
-
I am trying to UPDATE a table based on the result/value for the corresponding record in a separate query.
This is the basic syntax of...
