PostgreSQL多JOIN查询语法错误求助：第二处INNER JOIN报错

你的问题出在第一个INNER JOIN的ON子句末尾多了一个分号;——这个分号会直接终止当前查询语句，导致后面的INNER JOIN变成了独立的无效语句，从而触发syntax error at or near "INNER"的错误。

修正后的完整查询语句如下：

SELECT
  access.id,
  access.user_id,
  access.device_id,
  access.origin,
  access.creation_date
FROM
  table1 access
  INNER JOIN (
    SELECT
      device_id,
      MAX(creation_date) AS creation_date
    FROM
      table1
    GROUP BY
      device_id
  ) gaccess ON access.device_id = gaccess.device_id
  AND access.creation_date = gaccess.creation_date
  INNER JOIN 
    table2 AS jobinfo 
    ON gaccess.device_id = jobinfo.id

核心修正点：移除AND access.creation_date = gaccess.creation_date;末尾的分号，让第二个INNER JOIN成为当前查询的一部分，保持整个SQL语句的结构完整性。

内容的提问来源于stack exchange，提问作者Spanky