Vadim,
Unfortunately, not all subqueries can be handled by "normal" joins: NOT IN
is one example of this - joining by <> will give us invalid results.
What is you approach towards this problem?
I got an idea that one could reverse the order,
that is execute the outer first into a temptable
and delete from that according to the result of the
subquery and then return it.
Probably this is too raw and slow. ;-)
Personally, I was stuck by holydays -:)
Now I can spend ~ 8 hours ~ each day for development...
Oh, isn't it christmas eve right now in Russia?
best regards,
--
---------------------------------------------
Göran Thyni, sysadm, JMS Bildbasen, Kiruna