Select * from m t1
where t1.p not in (Select distinct t2.m_p from d t2)
where t1.p not in (Select distinct t2.m_p from d t2)
解决方案 »
- oracle大数据量表优化
- 请教:单词无序匹配实现
- 多表查询优化
- 求解Oracle 数据库主索引与唯一索引
- oracle简单的触发器问题,解决就结贴
- 555555555,终于出问题了,ORA-01081: cannot start already-running ORACLE - shut it down first
- RedHat9.0下安装ORACLE8.1.7 急!!!!!!!!!!!
- 这是8i版吗?这个版本怎么没有Create global temporary table 命令?
- 大家好,问一个问题,触发器里能不能有ddl
- Form Builder(9i)中不能用varray或嵌套表类型的域吗?
- 存储过程问题
- 安装Oracle10121遇到的问题?
demo@HASL>select * from m; P M_
---------- --
1 01
2 02
3 03demo@HASL>select * from d; MP D2 D3
---------- ---------- ----------
1 1 01001
1 2 01002
1 3 01003
2 4 02001
2 5 02002demo@HASL>Select * from m where m.p not in (Select mp from d ); P M_
---------- --
3 03