select name,case WHEN m.NAME is null THEN '' else m.NAME end NAME1 from sys_users 转载于:https://www.cnblogs.com/wdw31210/p/9358567.html