sql server - Return NULL data in SQL -

sql server - Return NULL data in SQL -

i have simple query returns user , assigned computer.

select dbocomputer.user, dbocomputer.computername dbocomputer dbocomputer.user in ('user1', 'user2', 'user3');

if 1 of users not in table, not homecoming user. however, comparing list of users , need know ones aren't in table.

how can create if user not exist in table, returns null in place?

i think should store list of users in table, illustration table dbouser, can left join. sample query be

select dbouser.user, dbocomputer.computername dbouser left bring together dbocomputer on dbouser.user = dbocomputer.user dbouser.user in ('user1', 'user2', 'user3');

sql sql-server