[Quote=引用 3 楼 theperfact 的回复:]
目的是把查询出的用户名从拼音改成汉字的。汉字拼音对应的信息在user表里
select userid from table2 把userid换成table1里的username
select select username from user where id=userid from table2
[/Quote]
SELECT B.username
FROM TABLE1 A JOIN TABLE2 B ON A.userid=B.userid