In SQLite, how do I query the changed values in two tables, and NULL out the matching values

If I have two rows in two different tables such as:

Table Name - Old

Table Name - New

The differences in the two tables are as follows:

• Row 1 (id=wx): title and views have not changed.
• Row 2 (id=np): The views has increased, while the title is the same.
• Row 3 (id=zo): The title has changed, while the views are the same.
• Row 4 (id=lf): Both title and views have changed.

Desired Result

I want a query that returns Table Name - New, but any values that haven't changed from Table Name - Old should be null, other than id. If the entire row has not changed, then the row should not be returned.

id is constant and does not change.

Query Result

The closest I have gotten is

SELECT * FROM new EXCEPT SELECT * FROM old;

but this does not null out the unchanged values.

Would be grateful for any help.

Join the tables and check if the corresponding columns are different:

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;

If the columns title and views may contain nulls then use IS NOT to compare them:

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

See the demo.