SQL查询, 数据存在于表一,但不存在于表二

表user

表user_info

期望结果:
查表user里面所有符合userName不存在于表user_info的数据
如图,username='Jockme’两个表都有,所以筛掉了.

我想到的SQL有:
1.
SELECT a.* FROM user a LEFT JOIN user_info b on a.userName=b.userName WHERE b.userName is NULL;

SELECT a.* FROM user a LEFT JOIN user_info b on a.userName=b.userName where a.userName not in (
SELECT c.userName FROM user c ,user_info d where c.userName=d.userName ) ;

SELECT * FROM user a WHERE a.userName <> (SELECT b.userName FROM user_info b,user c where c.userName=b.userName);

SELECT * FROM user a where not EXISTS (SELECT b.userName FROM user_info b where a.userName=b.userName);

感觉都不太满意, 望大佬指教.
而且假如user表的userName出现null. 这4句结果还不一样.