use SQL-Statement to parse and check the validity of your query.
(untested)

artist
=======================
Beautify your existence.

It's difficult to verify without knowing which database and which version of the database you're using.

That said, it's pretty easy to verify an update by turning it into a select and running it against your test database. It's also often possible to run it through your database's query analyzer, which should tell you about syntax errors.

Secondly, why cannot you just stick that SQL up the database and see what it will tell you. If you have an error in there, then take it one small step at a time.

P.S.: ObfuSQL is something... :)

Leonid Mamtchenkov aka TVSET

Abigail (you don't tell where you want it to be valid, so I won't tell you where it is invalid. Not that this is a Perl question anyway).

If your original code were rewritten as

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]='')
    )
[download]

Was that your question?

And this has what to do with Perl?