我正在嘗試顯示起點和終點之間的英里數。問題是我在撰寫查詢以正確顯示目標地址時遇到問題。只有一個位置表包含起點和終點的地址。我在這里做錯了什么？
我以為我會得到目的地和/或位置的正確地址，但它不起作用。
select dist.DistanceId,
dist.OriginLocationId,
l.Address,
dist.DestinationLocationId,
l.Address,
dist.DistanceInMiles
from DistanceMatrixFromGoogleMapsApi as dist
join locations as l
on l.id = dist.OriginLocationId or l.id = dist.DestinationLocationId
where OriginLocationId in (30506,53097,30362,30505,30377,30378,30594,30379,30514,30518,30517,55055,30360,30515,30516,30616,30512,30511,30510,30513,30381,49129)
and DestinationLocationId in (53097,30362,30505,30377,30378,30594,30379,30514,30518,30517,55055,30360,30515,30516,30616,30512,30511,30510,30513,30381,49129,34690)
這些是我得到的結果
uj5u.com熱心網友回復：
正如@Larnu 所建議的那樣 -
SELECT
dist.DistanceId,
dist.OriginLocationId,
orig.Address,
dist.DestinationLocationId,
dest.Address,
dist.DistanceInMiles
FROM DistanceMatrixFromGoogleMapsApi as dist
JOIN locations as orig
ON dist.OriginLocationId = orig.id
JOIN locations as dest
ON dist.DestinationLocationId = dest.id
WHERE dist.OriginLocationId in (30506,53097,30362,30505,30377,30378,30594,30379,30514,30518,30517,55055,30360,30515,30516,30616,30512,30511,30510,30513,30381,49129)
AND dist.DestinationLocationId in (53097,30362,30505,30377,30378,30594,30379,30514,30518,30517,55055,30360,30515,30516,30616,30512,30511,30510,30513,30381,49129,34690)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/533436.html