I have 2 tables,
This question is marked "community wiki".
asked 14 Jun '12, 10:11
Let's suppose the first table is called DISTANCES, the second table is called CITYNAMES.
You want something like
SELECT SOURCE.NameCity, TARGET.NameCity, DISTANCES.Distance FROM DISTANCES, CITYNAMES AS SOURCE, CITYNAMES AS TARGET WHERE DISTANCES.SourceCodeCity = SOURCE.CodeCity AND DISTANCES.TargetCodeCity = TARGET.CodeCity
answered 14 Jun '12, 12:52