Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does it have a sence?

Does it have a sence?

From: <y1799_at_yahoo.com>
Date: 31 Jan 2005 09:26:13 -0800
Message-ID: <1107192373.939831.74290@f14g2000cwb.googlegroups.com>


does the last two lines of the query have sense?

SELECT a.f1, a.f2, b.f1, b.f2FROM a, b
WHERE a.f1 = b.f1
AND a.f2 = b.f2
AND nvl(a.f2, '!') <> nvl(b.f2, '!')
Thanks,

P.S. It is not student work . Received on Mon Jan 31 2005 - 11:26:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US