MYSQL连接表多次
|
我有一张桌子，上面有一排排事件，每一个都有（在许多其他字段中）
addedbyuser
editedbyuser
deletedbyuser
INT
users
addedbyuser
eventid addedbyuser editedbyuser deletedbyuser
1 1 2 3
id username
1 name1
2 name2
3 name3
没有找到相关结果
已邀请:
1 个回复
徐百晴墓斜
select evn.eventid, us1.username as addedbyuser, us2.username as editedbyuser, us3.username as deletedbyuser, from events evn join users as us1 on evn.addedbyuser = us1.id join users as us2 on evn.editedbyuser = us2.id join users as us3 on evn.deletedbyuser = us3.id