inner join on null value
You don't get the row if the join is null because NULL cannot be equal to anything, even NULL.
If you change it to a LEFT JOIN, then you will get the row.
With an inner join:
select * from user as ujoin banstatus as b on u.banStatus=b.id1, '1', 1, 'Banned'
With a left join:
select * from user as uleft join banstatus as b on u.banStatus=b.id1, '1', 1, 'Banned'2, 'NULL', , ''
Using this test data:
CREATE TABLE user (id int, banstatus nvarchar(100));INSERT INTO user (id, banstatus) VALUES(1, '1'),(2, 'NULL');CREATE TABLE banstatus (id int, text nvarchar(100));INSERT INTO banstatus (id, text) VALUES(1, 'Banned');