如何使用JOIN从另一个表中选择一个值

Question

I just want to know one SQL query.

I've got two tables:

id | id_town
1  | 26



id | town
26 | Prague

What's the query if I need to print "Prague"? Thank you.

PhpMyAdmin prints #1052 - Column 'id' in on clause is ambiguous

I tried this

SELECT town FROM localities JOIN towns ON id = id_town

Answer 1

TRY THIS:

select b.town
from table1 a
inner join table2 b on a.id_town = b.id