110,502
社区成员
发帖
与我相关
我的任务
分享
select sales.log_id,users.login_name as name1,a.login_name as name2 from sales
inner join users on users.user_id = sales.buy_user_id
inner join users a on a.user_id = sales.sale_user_id
where a.login_name = '系统'
select
a.log_id as 日志,
b.login_name as 购买用户,
case a.sale_user_id when 0 then '系统' else c.login_name end as 出售用户
from sales a
left join users b on a.buy_user_id=b.user_id
left join users c on a.sale_user_id=c.user_id
where a.sale_user_id=0
select a.log_id as 日志, b.login_name as 购买用户, '系统' as 出售用户
from sales a
left join users b on a.buy_user_id=b.user_id
where a.sale_user_id=0