sql语句问题 多表查询的问题。。比如 现在有3个表 第一个表a字段1到10 第二个表a字段11到20 第三个表a字段21到30.我想联合这三个表 条件a字段的3到28的b字段的内容 在一列显示出来 该怎么写 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select b from tb1 where a>=3union allselect b from tb2union allselect b from tb3 where a<=28 ???select b from(select a,b from [表一]union allselect a,b from [表二]union allselect a,b from [表三])aawhere a between 3 and 28 select a1 from tb1union allselect a2 from tb1...select a10 from tb1... select b from (select * from tb1 union all select * from tb2 union all select * from tb3) c where c.a>=3 and c.a<=28 select b from(select a,b from [表一]union allselect a,b from [表二]union allselect a,b from [表三])aawhere a between 3 and 28 000001,000002,000003,...,099999,这种自增的列如何实现,是字符型,不是int型。 问个问题 SQL Server跨服务器取spid For xml 急,误删数据库中的sysusers表中的dbo这条数据 对image类型字段的全文检索 帮写sql存储过程 如何将两个表生成一个新表 自定义函数的UPDATE问题 SQL语句 where in(张三,张三,李四,张三,李四,张三)。怎么使记录集的顺序和()里的条件顺序一致。包括重复的要一样 请教问题 急!!! 请教问题 急!!!
union all
select b from tb2
union all
select b from tb3 where a<=28
select b from
(select a,b from [表一]
union all
select a,b from [表二]
union all
select a,b from [表三]
)aa
where a between 3 and 28
select a1 from tb1
union all
select a2 from tb1
...
select a10 from tb1
...
select b from (select * from tb1 union all select * from tb2 union all select * from tb3) c where c.a>=3 and c.a<=28
(select a,b from [表一]
union all
select a,b from [表二]
union all
select a,b from [表三]
)aa
where a between 3 and 28