Mysql LEFT JOIN后报错

Question

select *
from  table a
 LEFT JOIN (
            SELECT
                t1.id,
                t1.pro_id,
                t1.pdf_url,
                t1.oss_path,
                t1.create_date 
            FROM
                ( SELECT id, pro_id, pdf_url, oss_path, create_date from pmc_web_pdf HAVING 1 order by create_date DESC ) t1 
            GROUP BY
                t1.pro_id 
        ) pt2 ON pt2.pro_id = a.id 

在mybatis中执行报 Parameter index out of range (1 ＞ number of parameters, which is 0).错误 但是拿到navicat中可以执行 请问这是什么情况

Answer 1

```sql
SELECT
                t1.id,
                t1.pro_id,
                t1.pdf_url,
                t1.oss_path,
                t1.create_date 
            FROM
改成： select * from 
2:HAVING 1   删除

```