Re: mysterious behaviour where = (SELECT JAHR ...

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Fri, 24 Sep 2010 04:17:27 -0700 (PDT)
Message-ID: <5b853c8c-e8fa-428a-9479-0509c335df19_at_g18g2000vbn.googlegroups.com>

Hallo Norbert,
try it with aliases and you see that your first statement fails too.

select * from TST_TAB t WHERE YEAR = (SELECT y.YEAR FROM TST_ONE_YEAR y);

As Michael said, the year column is coming from tst_tab and this is true for all rows.

works as designed ... but not as expected ;-)

tschüss
Kay Received on Fri Sep 24 2010 - 06:17:27 CDT