有两张表：

tb1

http://s2/mw690/5fc93373g7ae47a7636c1&690两表合并查询" TITLE="sqlite 两表合并查询" />

tb2

http://s7/mw690/5fc93373g7ae47a9b5266&690两表合并查询" TITLE="sqlite 两表合并查询" />

想要合并为tb3的效果

http://s11/mw690/5fc93373gccecce0ab02a&690两表合并查询" TITLE="sqlite 两表合并查询" />

sql：

select t1.c_id,t1.o_id,t1.ct_id,t2.status,t1.name from tb1 as t1 left OUTER JOIN tb2 as t2 on t1.c_id=t2.c_id AND t1.o_id=t2.o_id AND t1.ct_id=t2.ct_id
UNION
select t2.c_id,t2.o_id,t2.ct_id,t2.status,t1.name from tb2 as t2 left join tb1 as t1 on t1.c_id=t2.c_id AND t1.o_id=t2.o_id AND t1.ct_id=t2.ct_id