Hi Val,
the below one is multiple IN queries with AND but not OR. correct ?
SqlQiuery with join table worked for IN Query and the following prepared
statement is not working.
List<String> inParameter = new ArrayList<>();
inParameter.add("8446ddce-5b40-11e6-85f9-005056a90879");
inParameter.add("f5822409-5b40-11e6-ae7c-005056a91276");
inParameter.add("9f445a19-5b40-11e6-ab1a-005056a95c7a");
inParameter.add("fd12c96f-5b40-11e6-83f6-005056a947e8");
PreparedStatement statement = conn.prepareStatement("SELECT p.name FROM
Person p join table(joinId VARCHAR(25) = ?) k on p.id = k.joinId");
statement.setObject(1, inParameter.toArray());
ResultSet rs = statement.executeQuery();
Thanks for your help.
On 28 October 2016 at 01:18, vkulichenko <valentin.kuliche...@gmail.com>
wrote:
> Hi,
>
> You can join multiple virtual tables in the same way:
>
> select p.name from Person p
> join table(id bigint = ?) i on p.id = i.id
> join table(name bigint = ?) j on p.name = j.name
>
> -Val
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/IN-Query-tp8551p8562.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
