我有一个表,其中有几个列的全名。我需要用第二个表中的用户ID更改每个表中的名称。
表1。
Opener | Closer | Manager
---|---|
Ed Woods | Rich Bell | Ed Woods
select uo.id as Opener,
uc.id as Closer,
um.id as Manager
from table1 t1
left join users uo on uo.Name_1 = t1.opener
left join users uc on uc.Name_1 = t1.closer
left join users um on um.Name_1 = t1.manager