a testcase
create table t1
(
c integer
)
//
create table t2
(
c integer
)
//
insert into t1 values(1)
//
delete from t1 where c in (select t1.c from t1,t2 where t1.c=t2.c(+) and
t2.c is null)
//
select * from t1
workaround
create table temp.t
(
c integer
)
//
insert into temp.t select t1.c from t1,t2 where t1.c=t2.c(+) and t2.c is
null
//
delete from t1 where c in (select c from temp.t)
//
select * from t1
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
