select t.name
from users_chars uc
inner join table_two t on uc.pos_zone = t.zone_id
What this means:
select t.name
tells the database which column you want to show/retrieve data for
from users_chars uc
get data from the users_chars table and give it an alias of "uc" (if the ID doesn't exist in UC, you won't be able to get the name from table_two)
inner join table_two t on uc.pos_zone = t.zone_id
pos_zone column from the users_chars table contains the same data as zone_id in table_two, so link those 2 together (typically a foreign key relationship, but it doesn't have to be). Also give table_two an alias of "t"
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…