take your pick
SELECT a.name, '' as role
FROM dbo.sysusers a INNER JOIN
dbo.sysmembers b ON a.uid <> b.memberuid
WHERE (a.name NOT LIKE 'sa%') AND (a.name NOT IN ('guest', 'public'))
union
SELECT '' as name, a.name as role
FROM dbo.sysusers a INNER JOIN
dbo.sysmembers b ON a.uid <> b.memberuid
WHERE (a.name NOT LIKE 'sa%') AND (a.name NOT IN ('guest', 'public'))
--or
SELECT a.name, (
SELECT a1.name
FROM dbo.sysusers a1 INNER JOIN
dbo.sysmembers b1 ON a1.uid <> b1.memberuid
WHERE a.name = a1.name AND (a1.name NOT LIKE 'sa%') AND (a1.name NOT IN ('guest', 'public'))
) as role
FROM dbo.sysusers a INNER JOIN
dbo.sysmembers b ON a.uid <> b.memberuid
WHERE (a.name NOT LIKE 'sa%') AND (a.name NOT IN ('guest', 'public'))
hope this helps