如果 a 和 b 结构一样 select a from tablename where b=1 union(unionall)select b from tablename where b=2;如果结构不一样,但两者有关联的 columnselect a.a , b.b from t1 a,t2 b where a.a=1 and b.b=2 and a.x=b.x;