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]
