Hi, 

We are using ignite 2.8.1, with this sql statement, SELECT * FROM orders p
WHERE  NOT exists (SELECT accountid FROM account b WHERE b.accountid =
p.accountid);

Retured result accountid actually exists in table account, change to NOT IN
also is not correct. But I have another table result is correct. 

Is there any suggestions? thanks.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Reply via email to