Er1c0
V2EX  ›  问与答

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

  •  
  •   Er1c0 · Oct 23, 2020 · 1196 views
    This topic created in 2214 days ago, the information mentioned may be changed or developed.
    3 replies  •  2020-10-23 18:53:40 +08:00
    MeteorCat
    MeteorCat
    Oct 23, 2020 via Android
    1
    我记得 inner join 加上 if 可以实现
    kx5d62Jn1J9MjoXP
    kx5d62Jn1J9MjoXP
    Oct 23, 2020 via Android
    2
    union ?
    kx5d62Jn1J9MjoXP
    kx5d62Jn1J9MjoXP
    Oct 23, 2020 via Android
    3
    select id, num, '' pwd from t1 where id =1
    union
    select id, '' num, pwd from t2 where id =1
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   913 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 19:40 · PVG 03:40 · LAX 11:40 · JFK 14:40
    ♥ Do have faith in what you're doing.