Hi, Thankyou for replying. *cache configration for all 4 tables : * SQL_PUBLIC_PERSON.SQL_PUBLIC_PERSON <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/SQL_PUBLIC_PERSON.SQL_PUBLIC_PERSON> SQL_PUBLIC_CITY.SQL_PUBLIC_CITY <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/SQL_PUBLIC_CITY.SQL_PUBLIC_CITY> SQL_PUBLIC_MEDICAL_INFO.SQL_PUBLIC_MEDICAL_INFO <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/SQL_PUBLIC_MEDICAL_INFO.SQL_PUBLIC_MEDICAL_INFO> SQL_PUBLIC_BLOOD_GROUP_INFO.SQL_PUBLIC_BLOOD_GROUP_INFO <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/SQL_PUBLIC_BLOOD_GROUP_INFO.SQL_PUBLIC_BLOOD_GROUP_INFO>
*Expecting result : *I am expecting 7 rows but only getting 4 . Also,data for column blood_group and universal_donor is missing. *Below are the screenshots and cache_configration of all 4 tables and the query result . * *Table :person * <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/person_table.png> *Table :city * <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/city_table.png> *Table :medical_info * <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/medical_info_table.png> *Table: blood_group_info * <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/blood_group_info_table.png> *Result of join query : * <http://apache-ignite-users.70518.x6.nabble.com/file/t2210/join_result.png> -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/