> -Original Message-
> From: Ravi Kumar. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 11, 2007 7:23 AM
> To: mysql@lists.mysql.com
> Subject: Join & update help
>
> Dear All,
>
> I have two tables T1 and T2.
>
> T1 has these columns: userid, passwo
Dear All,
I have two tables T1 and T2.
T1 has these columns: userid, password (userid is primary key)
T2 has these columns: sessionid, userid, logintime, logofftime
(sessionid is primary key)
I wish to add one column in T1 called last_login_time.
I want to populate this new column with max(
