select t1.froms as id from tb_message as t1 UNION select t2.tos as id from tb_message as t2
sqlite 合并2个表
原文:https://www.cnblogs.com/endv/p/12222333.html