UPDATE AccountAuthorizationInformation 
INNER JOIN AccountStatus ON 
    [AccountAuthorizationInformation].[Account_Authorization] = 
    [AccountStatus].[Account_Authorization] 
  SET AccountAuthorizationInformation.Settle_Date = 
    [AccountStatus].[Status_Date] 
  WHERE
    (
      ( [AccountStatus].[Account_Authorization] = 
        [AccountAuthorizationInformation].[Account_Authorization])
      And 
      ( [AccountAuthorizationInformation].[Settle_Date]='')
    )