Replace null values with another column in another table in SQLite

Question

Does anyone nows how to replace null values with another column in another table in SQLite

say this select statement

SELECT t1._id , t1.name , t2.img FROM
t1 JOIN t2 on (t1._id = t2._id);

if t1._id == null i want to return t2._id in that column

user158017 · Accepted Answer · 2012-03-22 18:24:01Z

3

What you want is a case statement

SELECT case when t1._id is null then t2._id else t1._id end as id, t1.name , t2.img FROM
t1 JOIN t2 on (t1._id = t2._id);

answered Mar 22, 2012 at 18:24

user158017

3,0011 gold badge31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1