RE: Riddle me this.....
Date: Thu, 9 Apr 2009 15:15:31 -0400
Message-ID: <8833494F383585499CB855121711D2631391993737_at_JBXEXVS02.fplu.fpl.com>
Sorry! The query works, it just returns no rows.
Jeremy
Consider the environment. Please don't print this e-mail unless you really need to.
-----Original Message-----
From: Michael McMullen [mailto:ganstadba_at_hotmail.com]
Sent: Thursday, April 09, 2009 3:16 PM
To: SHEEHAN, JEREMY; oracle-l_at_freelists.org
Subject: RE: Riddle me this.....
What "does not work" mean? No records returned, more,less, ora- error
What's the datatype? If there's implicit conversion going on change to
explicit. I've had so many hassles because of implicit conversion
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of SHEEHAN, JEREMY
Sent: Thursday, April 09, 2009 2:47 PM
To: oracle-l_at_freelists.org
Subject: Riddle me this.....
Ok. Here's an interesting question that some developers threw at me. I don't see anything wrong with the statement but it just does not work....
This statement does not work.....
select * from pjm_nm_sttl_component
where sttl_id in -- this statement has the 'in'
(select sttl_id_iso from isolink_pjm_sttl_estim_w_iso
where sttl_id = '131545258'
)
but this one does:
select * from pjm_nm_sttl_component
where sttl_id = -- this statement has the '='
(select sttl_id_iso from isolink_pjm_sttl_estim_w_iso
where sttl_id = '131545258'
)
i0zX+ n{+i^ Received on Thu Apr 09 2009 - 14:15:31 CDT