Hello, I have inserted 1000 cities now and 3 countries.
1st Country = 500 cities 2nd Country = 300 cities 3rd Country = 200 cities After executing first query select * from City c join Country cc on cc.Code = c.CountryCode; *record count is 0* after executing second query select * from City c join Country cc on cc.Code != c.CountryCode;* record count is 1200* This is completely opposite to your result , in first query you have 0 records and for second query you have some records. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
