Is this legal?

[sfullman]

Can you update joined tables as well as select them? e.g.

UPDATE
tableA,
tableB SET
tableB.PrimaryFirstName = tableA.PrimaryFirstName,
tableB.PrimaryLastName = tableA.PrimaryLastName
WHERE
tableA.UserName = tableB.UserName

Seems I remember doing this once before and it worked.

Sam

[TheIceman5]

if it works than its ok, if it dont work then its wrong, simple as that. your not going to go to jail for it.

[ultraslacker]

Depends on the dbms and version - mysql 3.23.x cannot, supposedly mysql 4.0.4 can

[tomhath]

I'd write it this way:

UPDATE tableB 
SET 
PrimaryFirstName = tableA.PrimaryFirstName, 
PrimaryLastName = tableA.PrimaryLastName 
FROM tableA
WHERE 
tableA.UserName = tableB.UserName