With a left join query, normal right table has not match should be returned empty fields, in Access to execute, the result is correct, when executed in Java, only to error, should be empty fields are populated with other values, seems to still use last one right table records of this field is not empty, filling the mystery!!!!!!

I checked before the execution of the SQL statement, there is no problem, and Access, SQL statements should not be the wrong question, o great god!