我有六张表, Table1 ,Table2 ,Table3,Table4,Table6,Table6
每张表都有,姓名,年龄,性别,等~~ 他们分别字段,是, T1_Name,T2_Name.....T6_Tame,
T1_Age,T2_Age .....T6_Age,
T1_Sex,T2_Sex .....T6_Sex,
最后,我要得到,六张表中,所有男姓的汇总表, 查找的结果多一个字段,Type 里面不同的表分别代表他们是从哪张表提出来的数据????急大家帮下
要求显示如下;
UserNam Age Sex Type aaaa 23 男 1 这条数据是表一提取出来的,
bbbd 18 男 2 这条数据是表二提取出来的
csfd 36 男 3 这条数据是表三提取出来的
csfd 36 男 4 这条数据是表四提取出来的
csfd 36 男 5 这条数据是表五提取出来的
csfd1 38 男 6 这条数据是表六提取出来的
csfd 36 男 6 这条数据是表六提取出来的
csfd 32 男 6 这条数据是表六提取出来的 我是SQL server 数据库,~~
每张表都有,姓名,年龄,性别,等~~ 他们分别字段,是, T1_Name,T2_Name.....T6_Tame,
T1_Age,T2_Age .....T6_Age,
T1_Sex,T2_Sex .....T6_Sex,
最后,我要得到,六张表中,所有男姓的汇总表, 查找的结果多一个字段,Type 里面不同的表分别代表他们是从哪张表提出来的数据????急大家帮下
要求显示如下;
UserNam Age Sex Type aaaa 23 男 1 这条数据是表一提取出来的,
bbbd 18 男 2 这条数据是表二提取出来的
csfd 36 男 3 这条数据是表三提取出来的
csfd 36 男 4 这条数据是表四提取出来的
csfd 36 男 5 这条数据是表五提取出来的
csfd1 38 男 6 这条数据是表六提取出来的
csfd 36 男 6 这条数据是表六提取出来的
csfd 32 男 6 这条数据是表六提取出来的 我是SQL server 数据库,~~
解决方案 »
- 怎么控制 TREE 中 checkbox 的默认状态?
- winform怎样罗列电脑上连接的所有摄像头?
- 求一性能测试的源码或方案!
- 求救:excel里怎样自动利用公式求和并写入一个单元格内?
- javascript 中怎么使用SAX
- 请问那为仁兄做过“系统信息的模块“??很急!!解决马上结账!
- 如何获取某文件夹下的所有图片?
- 如何在一个按钮或一个事件里实现把Access库中一个表的几个字段及内容插入到SQL中的一个表对应字段中?
- DataGrid中怎样让特定的几排只读
- .NET Framework SDK Beta 1安装时出现error 2894.internal Error 2894.126 错误如何解决??
- C#编程 将数组中数据写入SQL SERVER表中的一行????
- C#.net如何测试与SQL服务器连接上?
select T2_Name ,T2_Age ,T2_Sex,'这条数据是表二的' from Tabe2 where T2_Sex ='男' union
select T3_Name ,T3_Age ,T3_Sex,'这条数据是表三的' from Tabe3 where T3_Sex ='男' union
select T4_Name ,T4_Age ,T4_Sex,'这条数据是表四的' from Tabe4 where T4_Sex ='男' union
select T5_Name ,T5_Age ,T5_Sex,'这条数据是表五的' from Tabe5 where T5_Sex ='男' union
select T6_Name ,T6_Age ,T6_Sex,'这条数据是表六的' from Tabe6 where T6_Sex ='男'
select T1_Name as [UserNam] ,T1_Age as [Age] ,T1_Sex as [Sex] ,T1_Type as Type,'这条数据是表一的' as [Content] from Tabel where T1_Sex ='男' union
select T2_Name ,T2_Age ,T2_Sex,T2_Type,'这条数据是表二的' from Tabe2 where T2_Sex ='男' union
select T3_Name ,T3_Age ,T3_Sex,T3_Type,'这条数据是表三的' from Tabe3 where T3_Sex ='男' union
select T4_Name ,T4_Age ,T4_Sex,T4_Type,'这条数据是表四的' from Tabe4 where T4_Sex ='男' union
select T5_Name ,T5_Age ,T5_Sex,T5_Type,'这条数据是表五的' from Tabe5 where T5_Sex ='男' union
select T6_Name ,T6_Age ,T6_Sex,T6_Type,'这条数据是表六的' from Tabe6 where T6_Sex ='男'
SQL2005 创建视图!!! 爽!
SELECT T1_Name as [UserNam] ,T1_Age as [Age] ,T1_Sex as [Sex],[Type]=1 from Table1 where T1_Sex='男' union
SELECT T2_Name as [UserNam] ,T2_Age as [Age] ,T2_Sex as [Sex],[Type]=2 from Table2 where T2_Sex='男' union
SELECT T3_Name as [UserNam] ,T3_Age as [Age] ,T3_Sex as [Sex],[Type]=3 from Table3 where T3_Sex='男' union
SELECT T4_Name as [UserNam] ,T4_Age as [Age] ,T4_Sex as [Sex],[Type]=4 from Table4 where T4_Sex='男' union
SELECT T5_Name as [UserNam] ,T5_Age as [Age] ,T5_Sex as [Sex],[Type]=5 from Table5 where T5_Sex='男' union
SELECT T6_Name as [UserNam] ,T6_Age as [Age] ,T6_Sex as [Sex],[Type]=6 from Table6 where T6_Sex='男'
select T1_Name as [UserNam] ,T1_Age as [Age] ,T1_Sex as [Sex] ,T1_Type as Type from Tablel where T1_Sex ='男' union
select T2_Name ,T2_Age ,T2_Sex,T2_Type from Table2 where T2_Sex ='男' union
select T3_Name ,T3_Age ,T3_Sex,T3_Type from Table3 where T3_Sex ='男' union
select T4_Name ,T4_Age ,T4_Sex,T4_Type from Table4 where T4_Sex ='男' union
select T5_Name ,T5_Age ,T5_Sex,T5_Type from Table5 where T5_Sex ='男' union
select T6_Name ,T6_Age ,T6_Sex,T6_Type from Table6 where T6_Sex ='男'
create view table_view(Name,Age,Sex,Type)
AS
SELECT T1_Name,T1_Age,T1_Sex,T1_Type from Table1 where T1_Sex='男' union
SELECT T2_Name,T2_Age,T2_Sex,T2_Type from Table2 where T2_Sex='男' union
SELECT T3_Name,T3_Age,T3_Sex,T3_Type from Table3 where T3_Sex='男' union
SELECT T4_Name,T4_Age,T4_Sex,T4_Type from Table4 where T4_Sex='男' union
SELECT T5_Name,T5_Age,T5_Sex,T5_Type from Table5 where T5_Sex='男' union
SELECT T6_Name,T6_Age,T6_Sex,T6_Type from Table6 where T6_Sex='男'