三个表在SQL中联接 [英] Three tables join in SQL

问题描述

我是SQL的新手.我想在SQL中加入三个表.以下是我的查询，请检查并更正我错的地方-

I am newbie in SQL. I want to join three tables in SQL. Below is my query, please check and correct me where I am wrong -

表格:

• 卡:ID，代码，名称，CC
• PGM:ID，代码
• PGMeCode:ID，代码，抄送

查询:

Select *
FROM CARD
INNER JOIN PGMeCode PGMeCode.Code = CARD.Code AND PGMeCode.CC = CARD.CC
INNER JOIN PGM PGM.Code = Card.Code
WHERE Card.ID = 'SomeThing'

我不知道我在做什么错.请建议我！

I don't know what I am doing wrong. Please suggest me!!

先谢谢了.

推荐答案

您缺少表名称后的关键字ON.

You are missing the keyword ON, placed after the table name.

INNER JOIN tablename ON condition...

这篇关于三个表在SQL中联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！