I have tried according to your advises, but it failed, the result is incomplete.
I compared the SQL querys between yours and mine, and I found something different. For your SQL query "emp.depid = dep.id", dep.id is primary key of table Department. But for my SQL query "A.mid = B.mid", B.mid is NOT primary key of table B. I want to know whether this is the reason of the problem. If this is the reason, and I can not change the relation of the tables in my SQL query, how do I deal with it? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723p1795.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
