db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <da...@vancouvering.com>
Subject Using IN clause with multiple columns
Date Tue, 20 Apr 2010 22:20:59 GMT
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?

Thanks!

David

-- 
David W. Van Couvering

http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering

Mime
View raw message