[ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin... ] Lai Chao commented on TEIID-3023: --------------------------------- Hi, finnally I get access to the vdb by eclipse. But the situation is weird. I tried to select from 3 tables, it also get 10800+ records with some data miss. But I can get records if I add the lost data in condition. for example the sql 1 can get 10800+records, with data miss "centre='10001'". And I add the condition "centre='10001'" in the script as sql 2, I can get the data. Please advise. sql 1: select distinct a.columns,b.columns,c.columns from table_a a, table_b b,table_c c where a.centre = b.code and b.code = c.division and a.org='A00'; sql 2: select distinct a.columns,b.columns,c.columns from table_a a, table_b b,table_c c where a.centre = b.code and b.code = c.division and a.org='A00' and centre = '10001'; -- This message was sent by Atlassian JIRA (v6.2.6#6264)