is it possible to use the following update command in a stored procedure to get more speed? Now the command is given in the front-end client but takes some time .
The command is
UPDATE Tbl_Portfolio INNER JOIN TBL_NWA_Proj ON Tbl_Portfolio.Proj_account = TBL_NWA_Proj.Account SET Tbl_Portfolio.[NWA created] = True;
So when the two fields match in the two tables one field is set to true.
Thanks in advance.