SQL – UPDATE Statement with JOIN

UPDATE    A
SET        A.PAY_ORDER = B.PAY_ORDER
FROM    tbl_A A
JOIN    tbl_B B
ON        A.ACCT_NUMBER = B.ACCT_NUMBER
AND        A.PAY_DATE = B.PAY_DATE