Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Bug? SQL not returning correct rows.
> Why don't the results from Query 1 match the results from Query 3?
As both Query 1 and Query 3 look exactly like this, only differing in the IN clause
select bill_of_lading, qty
from ps_rsc_ar820_tbl
where bill_of_lading IN ( ... )
it should be impossible that Query 1 returns five records for bill_of_lading = M353655 and Query 3 returns just one. There are only two possible reasons for it as far as I can see it: 1. A bug in Oracle. 2. Your actual query differs from what you posted. The second reason is much more likely than the first one, however. Maybe you tried to simplify your query for posting it here and accidentally removed the critical part? Received on Tue Feb 13 2007 - 05:43:02 CST