第1个回答 2013-02-01
原理的确是你那个思路。但可以通过下面方式来简化写法
select
auserid,auserdes = (select userdes from user b where a.auserid = b.user),
buserid,buserdes = (select userdes from user b where a.bauserid = b.user),
cuserid,cuserdes = (select userdes from user b where a.causerid = b.user),
from userlist a来自:求助得到的回答本回答被提问者采纳