What is the UPDATE syntax for using two tables?

[Luan O'Carroll]

I have a SQL Server query that I am trying to port to Derby but I can't 
find the right syntax. Is there any documentation?

The SQLServer query is:
UPDATE TEMP_RATES
SET Level1=RATES.Level1
FROM TEMP_RATES INNER JOIN RATES ON TEMP_RATES .CODENO= RATES .CODENO
WHERE (RATES.UserID=306) AND ( TEMP_RATES.BusinessID=1)

Any ideas. I tried the SQL for ANSI,Informix,Oracle but none worked