By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table subscription_plans
(stripe_plan varchar(255));
insert into subscription_plans values
('Abcde123'),
('Abe123cd'),
('Ab1c2d3e'),
('123Abcde'),
('A1b2cde3'),
('321edcbA');
create table subscription_items
(stripe_plan varchar(255), quantity int, created_at date, updated_at date);
insert into subscription_items values
('Abcde123',1,curdate()-interval 3 day,curdate()),
('Abe123cd',1,curdate()-interval 13 day,curdate()),
('Ab1c2d3e',1,curdate()-interval 30 day,curdate());
/*with plain join*/
SELECT * FROM subscription_plans sp JOIN subscription_items si
ON sp.stripe_plan=si.stripe_plan;
| stripe_plan | stripe_plan | quantity | created_at | updated_at |
|---|---|---|---|---|
| Abcde123 | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| Abe123cd | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| Ab1c2d3e | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
/*with plain join & !=*/
SELECT * FROM subscription_plans sp JOIN subscription_items si
ON sp.stripe_plan!=si.stripe_plan;
| stripe_plan | stripe_plan | quantity | created_at | updated_at |
|---|---|---|---|---|
| Abcde123 | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| Abcde123 | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| Abe123cd | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| Abe123cd | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| Ab1c2d3e | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| Ab1c2d3e | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| 123Abcde | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| 123Abcde | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| 123Abcde | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| A1b2cde3 | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| A1b2cde3 | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| A1b2cde3 | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| 321edcbA | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| 321edcbA | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| 321edcbA | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
/*with left join*/
SELECT * FROM subscription_plans sp LEFT JOIN subscription_items si
ON sp.stripe_plan=si.stripe_plan;
| stripe_plan | stripe_plan | quantity | created_at | updated_at |
|---|---|---|---|---|
| Abcde123 | Abcde123 | 1 | 2021-05-15 | 2021-05-18 |
| Abe123cd | Abe123cd | 1 | 2021-05-05 | 2021-05-18 |
| Ab1c2d3e | Ab1c2d3e | 1 | 2021-04-18 | 2021-05-18 |
| 123Abcde | null | null | null | null |
| A1b2cde3 | null | null | null | null |
| 321edcbA | null | null | null | null |
/*with left join and null checking*/
SELECT * FROM subscription_plans sp LEFT JOIN subscription_items si
ON sp.stripe_plan=si.stripe_plan
WHERE si.stripe_plan IS NULL;
| stripe_plan | stripe_plan | quantity | created_at | updated_at |
|---|---|---|---|---|
| 123Abcde | null | null | null | null |
| A1b2cde3 | null | null | null | null |
| 321edcbA | null | null | null | null |