; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号

SELECT P.*, ROWNUM AS rowno FROM
 (SELECT * FROM "equipment_info","equipment_status","user","parking_lot"
 WHERE "equipment_info"."parking_id"="parking_lot"."id"
 and "equipment_info"."status"="equipment_status"."id"
 and "equipment_info"."principal_id"="user"."id") P
 WHERE ROWNUM < #{nextOffset,jdbcType=INTEGER}) T
 WHERE T.rowno >= #{pageOffset,jdbcType=INTEGER}

联表查询所有记录和equipment_info的记录条数

得到缺失右括号的问题

检查语法什么都没有问题

猜测可能是因为这种联表查询查记录个数有问题

改为左联表

SELECT P.*, ROWNUM AS rowno FROM
(SELECT * FROM "equipment_info" left join "parking_lot" on "equipment_info"."parking_id"="parking_lot"."id"
 left join "equipment_status" on "equipment_info"."status"="equipment_status"."id"
 left join "user" on "equipment_info"."principal_id"="user"."id") P
 WHERE ROWNUM < #{nextOffset,jdbcType=INTEGER}) T
 WHERE T.rowno >= #{pageOffset,jdbcType=INTEGER}

解决了问题