SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Old (`id` VARCHAR(2), `title` VARCHAR(20), `views` INTEGER);
✓
INSERT INTO Old (`id`, `title`, `views`) VALUES
  ('wx', 'How to clean a drill', '30'),
  ('np', 'Craziest Fails', '400'),
  ('zo', 'Eating Challenge', '8'),
  ('lf', 'JavaScript Tutorial', '0');
✓
CREATE TABLE New (`id` VARCHAR(2), `title` VARCHAR(20), `views` INTEGER);
✓
INSERT INTO New (`id`, `title`, `views`) VALUES
  ('wx', 'How to clean a drill', '30'),
  ('np', 'Craziest Fails', '450'),
  ('zo', 'This was a mistake', '8'),
  ('lf', 'Learning JavaScript', '20');
✓
SELECT o.id,
       NULLIF(n.title, o.title) title,
       NULLIF(n.views, o.views) views
FROM Old o INNER JOIN New n
ON n.id = o.id
WHERE n.title <> o.title OR n.views <> o.views


id
title
views


np
null
450

zo
This was a mistake
null

lf
Learning JavaScript
20


SELECT o.id,
       NULLIF(n.title, o.title) title,
       NULLIF(n.views, o.views) views
FROM Old o INNER JOIN New n
ON n.id = o.id
WHERE n.title IS NOT o.title OR n.views IS NOT o.views


id
title
views


np
null
450

zo
This was a mistake
null

lf
Learning JavaScript
20

id	title	views
np	null	450
zo	This was a mistake	null
lf	Learning JavaScript	20