I use PHP and MySQL
I have two tables. One of them is my main table named MAINTABLE
I have many coloumns in this table.
I have a referance table named RT_REFERANS_TAB2 whis has the values for my city names and languages
it is like below.
id rt_name rt_id rt_value
1 rt_sehir 1 New York
2 rt_sehir 2 Paris
97 rt_lang 1 German
98 rt_lang 2 English
id City Language1
I need to write an sql sentence to merge my main table and reference table and give out the desired results.
I insert into main talbe "1" for New York and 2 for Paris.
What I need to do is when I select form my database I want it to show the city name not the number.