请问怎么把两个表中的数据连在一块输出 select a.*,b.* from a,b 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * into 新表 from (select * from 表1union allselect * from 表2) tem insert into recordset select * from ainsert into recordset select * from b select a1 as c,a2 as d from a union allselect b1 as c,b2 as d from b select a1 c,a2 d from a union allselect b1,b2 from b select a1 as c,a2 as d from a union All select b1 as c,b2 as d from b 用union,但要注意数据要相容的 求一个通用的查询存储过程 请问下如下的视图该怎么创建呢? sql查询求解,谢谢!在线等待... 统计问题, 高分求救!!!!!!!!!!!!!!!!!!!! 统计两个表的问题 数据库关键字 求sql2000个人版下载地址,急!!(要不限速的) excel导入SQL提示错误 知识是无价的,所以我给最高分!(两表条件插入?) 求教~ 无法绑定由多个部分组成的标识符
select * from 表1
union all
select * from 表2) tem
insert into recordset select * from b
union all
select b1 as c,b2 as d from b
union all
select b1,b2 from b