Ok so I have seen a few posts on this but for some reason my code doesn't update the field, any help will be greatly appreciated.
UPDATE
Table_A
SET
Table_A.TID = Table_B.LastTID
FROM
Table_A
INNER JOIN Table_B ON (Table_A.CrdID = Table_B.CardholderID) AND (#Table_A.TD = Table_B.LastTDate)