select * from table1
where not exists (
select * from table2
where table2.field4=table1.field1
)
union all
select * from table2
where not exists (
select * from table2
where table2.field4=table1.field1
)
union all
select * from table2
解决方案 »
- ORA-00942: table or view does not exist
- 剔除重复数据
- 如何写一个触发器?
- 急急急,oracle客户端安装问题
- 高级技术问题
- Oracle数据库的按时间查询问题,很简单,但是我不会
- 我发觉在存储过程里select field into 变量 from dba_XXX,会报table OR view不存在的错
- 在客户端用什么图形工具可以建立数据库,谢谢高手?
- 在win2000 server中安装Oracle9i后,独立启动时录入用户名及密码总不能成功,怎么办?
- 请问一个pl/sql语句块(不是存储过程)可以有输出变量吗,应该怎么写?谢谢
- ASP调用ORACLE中包的函数出错,请大家帮我看一下。
- 在我安装server端后,实例oral 表空间ttdata 使用net8 config.. 指定service 出现问题,怎么也联不上啊!!!
union
select Field1 ,Field2,Field3 from table2
union
select table1.Field1 , table2.Field2, table1.Field3
from Table1,table2
where table1.Field1 = table2.Field1
and table1.Field3 = table2.Field3
我想得到的记录集是:
Field1 Field2 Field3
A1 B1 C1
A2 B8 C2
A3 B7 C3
A4 B4 C4
A6 B6 C6
A7 B9 C9
where not exists (
select * from table2
where table2.field4=table1.field1
)
union all
select field1,field5 as field2,field3 from table2,table1
where table2.field4=table1.field1
where not exists (
select * from table2
where table2.field4=table1.field1
)
union
select field4,field5,field6 from table2
where not exists (
select * from table1
where table2.field4=table1.field1
)
union
select field1,field5,field3 from table2,table1
where table2.field4=table1.field1