By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH Users AS (
SELECT 1 AS ID, '2017-01-01' AS LastPaymentDate UNION ALL
SELECT 2, '2018-02-05' UNION ALL
SELECT 3, '2018-04-06' UNION ALL
SELECT 5, NULL
),
ActivityLog AS (
SELECT 1 AS ID, '2017-01-01' AS ActivityDate UNION ALL
SELECT 1, '2017-05-17' UNION ALL
SELECT 3, '2018-05-20'
)
SELECT u.ID, u.LastPaymentDate
FROM Users u
LEFT JOIN ActivityLog a
ON u.ID = a.ID AND u.LastPaymentDate = a.ActivityDate
WHERE
a.ID IS NULL AND u.LastPaymentDate IS NOT NULL;
| ID | LastPaymentDate |
|---|---|
| 2 | 2018-02-05 |
| 3 | 2018-04-06 |