--- Dan Bron <[EMAIL PROTECTED]> wrote: > 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?
OK, so just instead of "PR in (?,?,...)" use "PR in (select distinct PR from z)". __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
