On 4/13/05, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote: > Hi! > > See inline comment. > > >>>>>>>>>>>> Jean T. Anderson wrote (2005-04-12 12:20:31): > > This table looks like a really handy reference, so I started taking a > > look at it. Regarding this item: > > > > >*E153* *Updatable queries with subqueries* No No > > > > Perhaps I'm missing the specific requirements for this item, but I think > > Derby supports it. For example, the derby func tests at > > https://svn.apache.org/viewcvs.cgi/*checkout*/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/update.sql > > include these statements: > > > > update t1 set int_col = > > (select t1.int_col > > from t1, t2 > > where t1.int_col = t2.int_col and t1.int_col = 1); > > > > update t1 set int_col = > > (select > > (select int_col > > from t1 > > where int_col = 2) > > from t2 > > where int_col = 1); > > > > Or does "Updateable queries with subqueries" mean something else? > > Yes, it does mean something else. It is constructs like > > E153 is related to expressions like > > select ..... where ...subquery... for update; > > -- > Bernt Marius Johnsen, Database Technology Group, > Sun Microsystems, Trondheim, Norway >
Hi Brent, We do support select .... where...subquery....for update; Some info on this can be found at http://incubator.apache.org/derby/manuals/reference/sqlj35.html#HDRSII-SQLJ-31783 Mamta
