db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Murphy <jim.mur...@pobox.com>
Subject Trying to "update from" - Derby 10.1
Date Sat, 12 Jan 2008 20:30:44 GMT

I need to update several rows with data from another table.  I don't know the
data values at the time I write the statement.  I just want to copy from one
table into a different table according to some criteria.

In another dialect I'd write:

UPDATE a set a.foo = b.bar FROM A a, B b where a.x = b.y;

How do I do the equiv in Derb 10.1?

Cheers,

Jim



-- 
View this message in context: http://www.nabble.com/Trying-to-%22update-from%22---Derby-10.1-tp14778557p14778557.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message