三个表在SQL中连接

发布于 2024-12-07 06:24:43 字数 392 浏览 0 评论 0原文

我是 SQL 新手。我想用 SQL 连接三个表。以下是我的查询，请检查并纠正我错误的地方 -

表：

CARD：ID，Code，Name，CC
PGM：ID，Code
PGMeCode：ID，Code，CC

查询：

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 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 -

Tables:

CARD: ID,Code,Name,CC
PGM: ID,Code
PGMeCode: ID,Code,CC

Query:

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!!

Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夜巴黎 2024-12-14 06:24:43

您缺少放置在表名称后面的关键字 ON。

INNER JOIN tablename ON condition...

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

INNER JOIN tablename ON condition...

回复收藏 0 原文

虚拟世界 2024-12-14 06:24:43

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

尝试这个查询

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

Try this query

回复收藏 0 原文

~没有更多了~