SQL Server Joining one table twice with another table

gjmwrych 于 2023-03-17 发布在其他

关注(0)|答案(1)|浏览(210)

I have below table A - which has From and To Location.
| From | To |
| ------------ | ------------ |
| ABC | FG |

Below table B - has the Location longitude and latitude

Zip	Lat	Long
ABC	90	80
FG	45	67

I want to combine the above two tables to get the below result wherein From Location has latitude and longitude and similarly To Location has Latitude and Longitude.

From	From_Lat	From_Long	To	To_Lat	To_Long
ABC	90	80	FG	45	67

Can someone help with the syntax to join table A and table B to get the desired results?

sql-server

来源：https://stackoverflow.com/questions/75742828/joining-one-table-twice-with-another-table

1条答案

按热度按时间

v8wbuo2f1#

You'll need to use two join clauses:

SELECT [from], f.lat, f.long, [to], t.lat, t.long
FROM   tab_a a
JOIN   tab_b f ON a.[from] = f.zip
JOIN   tab_b t ON a.[to] = t.zip

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server Joining one table twice with another table

1条答案

相关问题

热门标签

最新问答