Looks that I missed/haven't scrolled down the reference: http://db.apache.org/derby/docs/dev/tools/rtoolsijcomrefshow.html. One example for IN before FROM related example. John