Have you tried using Any instead of In? Someone posted that there was a bug that Any and In were showing different results even though they should return the same. ________________________________________________________________________________
Have tried not exists like shown: select count(a.id) from bas_agnums a where not exists(select b.ag_id from va_ums b where b.ag_id=a.id group by b.ag_id) When i commit the query i never get a result. Query hangs. Same with "exists" statement. I don't believe what's wrong. Hope for some hints. with best rgds. Albert Albert Steckenborn schrieb: > hi folks, > > following problem with actual maxdb release: > I have found no way to delete rows from table A without a reference in > table B. > Table A 138000 rows > Table B 380000 rows > > select count(ID) from bas_agnums where id in(select distinct id from > bas_agnums,va_ums where bas_agnums.id=va_ums.ag_id(+) and va_ums.ag_id > is null) > result: 55865 > That is ok > > Now i want to delete these rows with following statement: > > delete from bas_agnums where id in(select distinct id from > bas_agnums,va_ums where bas_agnums.id=va_ums.ag_id(+) and va_ums.ag_id > is null) > > result: No rows updated or deleted. No Result > > That is wrong > > Have tried a lot of ways and found nothing that is working. > > Any hints????? > > with best rgds. > > Albert > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
