Oleg, >Here's sqlite test. >"in (?,?)" should have appropriate number of "?"'s.
I just got back to this SQL question now. I have not yet read your msg in detail, but the quote above (appears to) indicate that the query itself must contain all the symbols I want to look up. That won't work, I need to join symbols from table y on table x. Did you see my example data? -Dan ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
