H2数据库子查询

Question

SELECT base2.id, base2.padno, base1.padgroup FROM base2 LEFT JOIN base1 ON base2.padno LIKE CONCAT(base1.padgroup,'%') ORDER BY padgroup DESC

H2数据库执行该语句的时候抛出异常，单语句没有异常。刚刚开始用H2数据库，H2数据库是不是对子查询支持并不那么好？