SQL: Update .. from .. where ..

Hi, I am whether I can update a field in one table from valuse in another table using a simple SQL Statement ?

the Tables are :         

	T1			T2
	Code			Code
	Value			Value
	otherstaff..

where Code is the PK of both tables (1 to 1)

and I think the Update statement should be:

Update T1 set T1.Value = T2.Value
From T1, T2
where T1.Code = T2.Code (Runs perfect in SYBASE !)

but check the Oracel Server Language Refernece book, the Update can not have a FROM clause, but then How you updating a field from another table in SQL ?

Thanks for any help

Y. Liang    Received on Tue Jun 27 1995 - 00:00:00 CEST