如何把两个sql语句结果 横向合并起来

Question

select field1 from table1 where field1 like * ;
select field2 from table2 where field2 like * ;
如何横向合并起来 union all 用过 是 纵向合并

Answer 1

select table1 .field1, table2. field2 from table1
full join table2 on 1=1

追问

同种like筛选语句我成功了，
但是如果 两个表的 like 语句 有区别呢？

追答

select table1 .field1, table2. field2 from table1
full join table2 on 1=1
where table1. field1 like '%...'
and table2. field2 like '%...'

追问

我这么写的没对，[Err] 1054 - Unknown column 'pms_inverter_day_t.busi_code' in 'field list'