Left join

Transact-SQL
1

hello,
every day I would like to run a query which looks at table1 and table2 and returns everything in table 1 which is not in table2.
here the two tables have in common the columns date and code .
can you see what is wrong with this query ? thanks


select 
    getdate() , count(fl."LoginId"), fl."LatestCode" 
from 
    "Logins" as fl
    left join "tbl_LoginIdCount" as lc on date(fl."LoginTimestamp") = lc."Date" and fl."LatestCode" = lc."Code"
WHERE
    lc."Date" is NULL and lc."Code" is null
group by 
    fl."LatestCode";
2

WHERE
lc."Date" is NULL
OR
lc."Code" is null

3

thanks