java.sql.SQLException: 第 1 行: ';' 附近有语法错误......怎么解？

public static void zongkuotermid() {

Zongkuochuli c = new Zongkuochuli();
con = c.getConnection();
try {
sql = con.createStatement();
sql.executeUpdate("update csnlibrary.dbo.allInclusive set enterDate = LEFt((SELECT MIN(code) FROM csneschool.dbo.term), 4) + '-09-01' "
+ " WHERe (CONVERT(varchar(10), enterDate, 120) < (LEFT ((SELECt MIN(code) FROM csneschool.dbo.term), 4) + '-09-01');");
} catch (SQLException e) {
e.printStackTrace();
}

}

sqlException 就是SQL语句执行错误，你有没有判断SQL语句的准确性？ 我觉得你SQL好怪、

con = c.getconnection(); con 有没有被定义？