Yes, thanks, that should work! David
On Wed, Apr 21, 2010 at 12:55 AM, Knut Anders Hatlen <[email protected]>wrote: > On 04/21/10 12:20 AM, David Van Couvering wrote: > > I have two tables with columns a,b that together comprise the primary > > key. > > > > In Oracle I can do something like DELETE FROM FOO WHERE (a, b) IN > > (SELECT a, b FROM BAR WHERE MODIFIED = 1) > > > > but in Derby this gives me a syntax error saying Error: Syntax error: > > Encountered "," at line 1, column XX. > > > > The documentation for "IN" also suggests that the subquery can only > > return a single column. > > > > How would I do this, when my tables have a multi-column primary key > > like above? > > > > Hi David, > > Would this work? > > DELETE FROM FOO WHERE EXISTS > (SELECT * FROM BAR WHERE MODIFIED = 1 > AND BAR.A = FOO.A AND BAR.B = FOO.B) > > > -- > Knut Anders > > -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering
