Stef Mientki <s.mien...@ru.nl> wrote: > create table RT1 ( PID integer, V1 text ); > insert into RT1 values ( '684', 'aap' ); > insert into RT1 values ( '685', 'other empty' ); > create table RT2 ( PID integer, V2 text ); > insert into RT2 values ( '684', 'beer' ); > insert into RT2 values ( '686', 'other empty' ); > select RT1.*, RT2.* > from RT1 > left join RT2 on RT1.PID = RT2.PID > union > select RT1.*, RT2.* > from RT2 > left join RT1 on RT1.PID = RT2.PID > where RT1.PID IS NULL; > > Now I want to combine the columns PID, so the result would look like > > PID V1 V2 > 686 from RT2 > 684 from RT1 from RT2 > 685 from RT1
select coalesce(RT1.PID, RT2.PID) as PID, RT1.V1, RT2.V2 ... Modifying the second select clause is left as an exercise for the reader. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
