mysql 双表多个外建怎么查询

Question

mysql 双表多个外建怎么查询，让id显示出对应的名字，效果显示图4那样子

Answer 1

select t.title,t.BeginTime,e1.Name,e2.Name,t.priority from t_task t inner join t_employee e1 on t.TaskSenderId= e1.id inner join t_employee e2 on t.TaskReceiverID=e2.id