You want to concatenate them, not join them. So, use the concatenation operator:
select (first_name || ' ' || last_name) as full_name from t;
SQLite does not support generated columns. But if you want
full_name to be available for more than one query, then you can define a view:
create view v_t as select t.*, (first_name || ' ' || last_name) as full_name from t;
Gordon Linoff posted this
Have an answer?