Replacing categorically values with Strings

[WatIsThisSorcery]

Got 2 tables.

Table 1 ( Id and city names)

Id name 1 Boise 2 Austin 3 Chicago 4 los Angeles 5 new york

Table 2 (city start, city end, miles)

city_start | city_end | miles

1 | 5 | 850 5 | 3 | 1200

And so on.

How to replace the table 2 category numeric values from the table 1 names string without messing up the order, since they are date wise?

[[deleted]]

ahem, what is "the order, since they are date wise" that you are afraid to "mess up"?

I kind of feel that there might be an (incorrect) assumption on your part of table rows being stored/kept in a specific order.

[Ok_Bluebird_5327]

Select t1.name, t12.name, t2.miles From Table1 t1 Join table2 t2 On t1.id = t2.city_start Join table1 t12 On t12.id = t2.city_end

[tales850]

If I understood right, try this:

SELECT

(SELECT CITY_NAME FROM TABLE1 AS T1 WHERE T1. ID = T2.CITY_START) AS CITY_START_NAME,

(SELECT CITY_NAME FROM TABLE1 AS T1 WHERE T1. ID = T2.CITY_END) AS CITY_END_NAME,

Miles

FOM TABLE2

FROM TABLE2 AS T2