Re: The result of cross-cache SQL joins is incomplete.

[iceguo]

Thank you for your kindness.

Could you please help me to collocate the following object?

CREATE TABLE  T1 
 ( LAT_ID        SMALLINT,
   DEV_ID    VARCHAR(20),
   DEV_LV    SMALLINT
 );
  
  CREATE TABLE  T2
 ( THE_DATE              DATE,
   DEV_ID           VARCHAR(20),
   DEV_LV          SMALLINT
 );
 
 CREATE TABLE  T3 
 ( ID         INTEGER           PRIMARY KEY    NOT NULL,
   DEV_TYPE   VARCHAR(200),
   DEV_ID     VARCHAR(100)
 );

 p.s:
table T1 and T2 have no primary key.

SQL query:
SELECT t1.* from t1,t2,t3 where t2.DEV_ID = t1.DEV_ID and 
                                             t2.DEV_LV = t1.DEV_LV and 
                                             t1.DEV_ID = t3.DEV_ID;



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723p1819.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.