SQL连接表行数据

发布于 2024-12-17 11:26:15 字数 389 浏览 0 评论 0原文

我有这个查询：

SELECT Stops_edited_small1.AtcoCode, ABC.Naptan_Atco, ABC.Stop_Code
FROM Stops_edited_small1
INNER JOIN ABC
ON Stops_edited_small1.AtcoCode=ABC.Naptan_Atco

它返回一个不错的结果表，但我真正想做的是，如果：

Stops_edited_small1.AtcoCode=ABC.Naptan_Atco

我想将 ABC.Stop_Code 中的数据放入 Stops_edited_small1.ABCStop_Code （当前没有值）。

非常感谢。

原文

I have this query:

SELECT Stops_edited_small1.AtcoCode, ABC.Naptan_Atco, ABC.Stop_Code
FROM Stops_edited_small1
INNER JOIN ABC
ON Stops_edited_small1.AtcoCode=ABC.Naptan_Atco

Which returns a nice results table, but what I actually want to do, is, if:

Stops_edited_small1.AtcoCode=ABC.Naptan_Atco

I want to put that data from ABC.Stop_Code into Stops_edited_small1.ABCStop_Code (which has currently got no values).

Many thanks.

分享到QQ

分享到微博

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

发布评论

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

煞人兵器 2024-12-24 11:26:15

UPDATE     Stops_edited_small1
SET        Stops_edited_small1.ABCStop_Code = ABC.StopCode
FROM       Stops_edited_small1
INNER JOIN ABC ON Stops_edited_small1.AtcoCode = ABC.Naptan_Atco

UPDATE     Stops_edited_small1
SET        Stops_edited_small1.ABCStop_Code = ABC.StopCode
FROM       Stops_edited_small1
INNER JOIN ABC ON Stops_edited_small1.AtcoCode = ABC.Naptan_Atco

回复收藏 0 原文

~没有更多了~