使用不同的别名两次联接用户表。首先连接到
from列，然后连接到
to列。
select m.*, u1.userName as Sender, u2.userName as Recipient from tabMessages as m inner join tabUsers as u1 on u1.userId=m.msgFrom inner join tabUsers as u2 on u2.userId=m.msgTo where m.msgId = @someParameter;
使用不同的别名两次联接用户表。首先连接到
from列，然后连接到
to列。
select m.*, u1.userName as Sender, u2.userName as Recipient from tabMessages as m inner join tabUsers as u1 on u1.userId=m.msgFrom inner join tabUsers as u2 on u2.userId=m.msgTo where m.msgId = @someParameter;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
