- 论坛徽章:
- 0
|
可以用下面的语句获取数据,
select *
from f_daily_purchase_order a
where exists(select 1
from t_f_daily_purchase_order
where po_no = a.po_no
and sid_str = a.sid_str
and sid_item_c = a.sid_item_c)
但是却不能用
delete from f_daily_purchase_order a
where exists(select 1
from t_f_daily_purchase_order
where po_no = a.po_no
and sid_str = a.sid_str
and sid_item_c = a.sid_item_c)
我的oracle版本是
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
不知哪位高人曾经碰到过相同的情况,并求解决之道!
在此谢过了!
[ 本帖最后由 suomaliren 于 2006-7-12 09:19 编辑 ] |
|