Luan O'Carroll <[EMAIL PROTECTED]> 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
