如果你希望如下显示valueB/D
3
B的值
3
D的值; ...select 表1.A,表1.B from 表1 where 表1.A=3 union all select 表2.C,表2.D from 表2 where 表2.C=3如果你希望这样显示value B
D3
B的值 D的值那就select t1.A,B,D from (select A,B from a表) as t1 ,(select C,D from b表)as t2 where t1.A='3' and t2.C=t1.A
|
|