怎么把两个 id=1 的查询结果整成一个结果，只能用 mysql 实现

This topic created in 2053 days ago, the information mentioned may be changed or developed.

3 replies • 2020-10-23 18:53:40 +08:00

MeteorCat

Oct 23, 2020 via Android

我记得 inner join 加上 if 可以实现

kx5d62Jn1J9MjoXP

Oct 23, 2020 via Android

union ？

kx5d62Jn1J9MjoXP

Oct 23, 2020 via Android

select id, num, '' pwd from t1 where id =1
union
select id, '' num, pwd from t2 where id =1