>I have a table that contains the field citycode and another table with the field besides cityname. How do I get an extra table with citycode and cityname by a Select?
select T2.* from Table1 T1 inner join Table2 T2 on T1.CityCode = T2.CityCode
Is it what you need?
If it's not broken, fix it until it is.
My Blog 
