Thread

Re: [HACKERS] subselect

Goran Thyni <goran@bildbasen.se> — 1998-01-05T13:28:25Z

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