How to write a query to display data where the date is not equal to the given one?

Question

PostgreSQL

subscriptions table (id, user_id, created_at, updated_at)
subscription_stats table (id, user_id, date)
Output without where:

select * from "subscriptions"
left join "subscription_stats"
on "subscriptions"."user_id" = "subscription_stats"."user_id"
limit 20

How to display a list of users whose date is not equal to the given one? I've tried both <> and != and it doesn't output anything...

select * from "subscriptions"
left join "subscription_stats"
on "subscriptions"."user_id" = "subscription_stats"."user_id"
where "subscription_stats"."date" <> '2019-05-16'

Decision:

select "subscriptions"."user_id" from "subscriptions"
left join "subscription_stats"
on "subscriptions"."user_id" = "subscription_stats"."user_id"
where ("subscription_stats"."date" <> '2019-05-16' or ("subscription_stats"."date") is null)
limit 20

Answer 1

Are you sure you need a left join?