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 -> Oracle Bug? SQL not returning correct rows.

Oracle Bug? SQL not returning correct rows.

From: <zugzug21_at_gmail.com>
Date: 12 Feb 2007 09:25:32 -0800
Message-ID: <1171301132.396592.187150@a75g2000cwd.googlegroups.com>


Environment:
ps_rsc_ar820_tbl = Table exists in the Oracle 9i DB I'm logged onto @opis = DB Link to an 8i DB

Problem:
Why don't the results from Query 1 match the results from Query 3?

Query 1 is returning more than the desired number of rows. When I run Query 2
independently it returns the correct number of rows and values. Query 3 is what
I expected to receive from Query 1. Query 4 works properly and it is just
Query 1 written without using an IN clause.

--Query 4 Returns (This is correct)

M353655	21085
M353677	17243

Any clarification on why this is happening would be appreciated!

-Ryan
Received on Mon Feb 12 2007 - 11:25:32 CST

Original text of this message

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