mysql - mysql根据多个id选择字段

Question

有两个表表1

id --------- 姓名

10001ABC

10002 XYZ

表2

fromid ------ toid ------ 消息

10001 10002嗨

我希望结果是这样的

名称-----名称1------消息

Abc Xyz Hi

帮助将不胜感激

Answer 1

select t1.name as name, t2.name as name1, t3.message
from table2 as t3
join table1 as t2 on t3.fromid = t2.id
join table1 as t1 on t3.toid = t1.id

我想这可以满足你的问题。