Best way to UPDATE records

[tdnxxx444]

I have two tables that I want to update, Account and CcInfo. Should I update it like this:

UPDATE Account
SET Accounts.Username = 'test',
Accounts.Password = 'password'
WHERE Account.AccountId = '1'

UPDATE CcInfo
SET CcInfo.Number = '1111111111111111',
CCInfo.ExpDate = '0408',
CCInfo.Cvv = '123'
WHERE CcInfo.CcInfoId= '5'

OR

UPDATE Accounts, CcInfo
SET Accounts.Username = 'test',
Accounts.Password = 'password',
CcInfo.Number = '1111111111111111',
CCInfo.ExpDate = '0408',
CCInfo.Cvv = '123'
WHERE CcInfo.CcInfoId= '5'
AND Accounts.AccountId = CcInfo.AccountId

[weekender]

do it as two different queries, makes it easier to debug if you need to

and you don't need to reference fields absolutely if you only have one table in the query - use Username instead of Accounts.Username

adam