SQL Key

SELECT a.OriginDestinationKey
       , a.Origin
       , a.Employee
       , CAST(LLo.Lat AS Decimal(8,6)) AS OriginLat
       , CAST(LLo.Long AS Decimal(9,6)) AS OriginLong
       , a.Destination
       , CAST(LLd.Lat AS Decimal(8,6)) AS DestinationLat
       , CAST(LLd.Long AS Decimal(9,6)) AS DestinationLong
       , a.iDistance
       , a.Distance
       , a.iTravelTime
       , a.TravelTime
       FROM aGoogleData a
    LEFT OUTER JOIN aGoogleDataLatLong LLo
    ON LLo.Location = a.Origin
        LEFT OUTER JOIN aGoogleDataLatLong LLd
        ON LLd.Location = a.Destination