select zd01 as tb1zd1,zd02 as tb1zd2,zd03 as tb1zd3 from tabel1
union all
select zd01 as tb2zd1,zd02 as tb2zd2,zd03 as tb2zd3 from table2
union all
select zd01 as tb2zd1,zd02 as tb2zd2,zd03 as tb2zd3 from table2
解决方案 »
- 备份除数据库(不含数据所有东东)的请教,请前辈指点!
- sql语句基本问题
- 这条句子怎么写?
- 数据库故障问题-FCB为能打开
- 统计的复杂问题
- 在sqlAGENT里的自动检查数据库正不正常的任务一段语句现在不能执行了,请给段语句或解释下为什么不能执行
- SQL server2000数据异地同步的问题
- 服务器的SQL2000的设置问题,急!
- 写一个查询,有二个表aaa有一字段(name),bbb有二字段(name,sex),我要查询aaa的列表
- 如何在SQL2000 中实现在结果集中加一个表示排名的列 下面是我的SQL
- 一个很简单的问题,请进!!在线等待帮助!
- ?**表里面的32位的UNID是自动生成的吗??不会是自己定义的吧??谢谢
FROM table1
WHERE zd03='aaa'
union all
SELECT 'null' as tb1zd1,'null' as tb1zd2,'null' as tb1zd3,tb1zd1,tb1zd2,tb1zd3
FROM table2
WHERE zd03='aaa'
FROM table1
WHERE zd03='aaa'
union all
SELECT 'null','null','null',tb1zd1,tb1zd2,tb1zd3
FROM table2
WHERE zd03='aaa'
union all
SELECT tb1zd1=null, tb1zd2=null, tb1zd3=null, tb2zd1=table2.zd01, tb2zd2=table2.zd02, tb2zd3=table2.zd03 from table2 where zd03='aaa') aa
ORDER BY
....
SELECT zd01 as tb1zd1,zd02 tb1zd2,zd03 tb1zd3,null as tb2zd1,null as tb2zd2,null,as tb2zd3
FROM table1
WHERE zd03='a'
union all
SELECT null as tb1zd1,null as tb1zd2,null as tb1zd3,zd01 tb2zd1,zd02 as tb2zd2,zd03 as tb1zd3
FROM table2
WHERE zd03='a'
) as x
order by isnull(tb1zd2,tb1zd3)
union all
select * from table1 right join table2 on 1=1 where tb2zd3='aaa' and tb1zd1=null and tb1zd2=null and tb1zd3=null不知道这样行不行?各位大虾请指点,我是新手:)
你的程序很厉害
我看不懂
能解释一下么"table1 left join table2 on 1=1 "
FROM table1
WHERE zd03='aaa'
union all
SELECT 'null','null','null',tb1zd1,tb1zd2,tb1zd3
FROM table2
WHERE zd03='aaa'这种方法最便捷了