UPDATE using values from other table.

[August Zajonc]

Mysql doesn't like the following:

UPDATE ActiveSessions LEFT JOIN Users ON Users.UserID =
ActiveSessions.UserID SET ActiveSessions.Status = Users.Status;
or
UPDATE ActiveSessions, Users SET ActiveSessions.Status = Users.Status WHERE
Users.UserID = ActiveSessions.UserID;

Is this something that looks like it SHOULD work?

AZ