我正在尝试连接两个表,由于某些原因,我不断得到:错误:“join”处或附近出现语法错误我的代码是:
SELECT c.visit, d.cakeFROM customer c, INNER JOIN desert d ON c.visit = d.visitLIMIT 10;
SELECT
c.visit,
d.cake
FROM
customer c,
INNER JOIN desert d
ON c.visit = d.visit
LIMIT 10;
4dbbbstv1#
不需要逗号:
SELECT c.visit, d.cakeFROM customer c -- hereINNER JOIN desert d ON c.visit = d.visitLIMIT 10;
customer c -- here
1条答案
按热度按时间4dbbbstv1#
不需要逗号: