db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luan O'Carroll <lu...@xoetrope.com>
Subject What is the UPDATE syntax for using two tables?
Date Thu, 24 May 2007 18:28:07 GMT
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

Mime
View raw message