select aa from a union all select bb from b union all select cc from c 或者 select aa,bb=(select bb from b), cc=(select cc from c) from a
select aa = (select top 1 aa from a), bb = (select top 1 bb from b), cc = (select top 1 cc from c)
select top 1 aa from a union all select top 1 bb from b union all select top 1 cc from c
横排:select aa = (select top 1 aa from a), bb = (select top 1 bb from b), cc = (select top 1 cc from c)竖排:select top 1 aa from a union all select top 1 bb from b union all select top 1 cc from c
union all
select bb from b
union all
select cc from c
或者
select aa,bb=(select bb from b),
cc=(select cc from c)
from a
aa = (select top 1 aa from a),
bb = (select top 1 bb from b),
cc = (select top 1 cc from c)
union all
select top 1 bb from b
union all
select top 1 cc from c
aa = (select top 1 aa from a),
bb = (select top 1 bb from b),
cc = (select top 1 cc from c)竖排:select top 1 aa from a
union all
select top 1 bb from b
union all
select top 1 cc from c