postgresql的“join”处或附近出现语法错误

rbpvctlc  于 2021-07-24  发布在  Java
关注(0)|答案(1)|浏览(349)

我正在尝试连接两个表,由于某些原因,我不断得到:
错误:“join”处或附近出现语法错误
我的代码是:

  1. SELECT
  2. c.visit,
  3. d.cake
  4. FROM
  5. customer c,
  6. INNER JOIN desert d
  7. ON c.visit = d.visit
  8. LIMIT 10;
4dbbbstv

4dbbbstv1#

不需要逗号:

  1. SELECT
  2. c.visit,
  3. d.cake
  4. FROM
  5. customer c -- here
  6. INNER JOIN desert d
  7. ON c.visit = d.visit
  8. LIMIT 10;

相关问题