db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: What is the UPDATE syntax for using two tables?
Date Fri, 25 May 2007 07:29:23 GMT
Luan O'Carroll <luano@xoetrope.com> writes:

> 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

What is the error message you are seeing? Which part of the query is
Derby choking on?

-- 
dt


Mime
View raw message