astonishing(?) sql

From: Marcin Buchwald <Marcin.Buchwald_at_agora.pl>
Date: Mon, 21 Jan 2002 12:57:31 +0100
Message-ID: <3C4C022B.76E0B2A6@agora.pl>

Let promocja and kategoryzacja by any tables with master detail relationship.
The query below completely ignores the last where clause. It produces rows with value of the third column different from 216.

select t.rowid, t.detid, t.masnic
 from (select *

         from (select k.xx detid, p.xx masnic
                 from promocja p, kategoryzacja k
                where p.kat_xx=k.xx
         ) order by masnic ) t

where t.masnic=216
/

Can You explain this?

Regards,

        Marcin Received on Mon Jan 21 2002 - 05:57:31 CST