Re: SQLPlus Mystery

Just out of interest - what are the fourteen rows that aren't being returned !!!

Pete

On Wed, 16 Dec 1998 17:09:02 -0500, "Tansel Ozkan" <tansel_at_openix.com> wrote:

>We are having a strange problem:
>
>The same query is returning different number of records when
>run from SQLPlus and SQLWorksheet. The SQL statement below
>is returning 180 records when run from SQLPlus, and 194 records
>from SQLWorksheet.
>
>select a.doc_id||'|'||a.doc_title||'|'||b.stock_qty||'|'||
>b.committed_qty||'|'||a.reorder_qty||'|'||a.samp_cutoff_qty
>from documents a,doc_stock b, doc_int_mapping c
>where a.doc_id=b.doc_id and
>b.doc_id=c.doc_id and
>c.int_code='PACK'
>
>The interesting is that if I run the same query from SQLPlus
>with count(*) instead of a select field, I get the same number of records
>as run from SQLWorksheet.
>
>select count(*)
>from documents a,doc_stock b, doc_int_mapping c
>where a.doc_id=b.doc_id and
>b.doc_id=c.doc_id and
>c.int_code='PACK'
>
>Any ideas to help me solve this mystery?
>
>Tansel
>
>
>
>
>
Received on Thu Dec 17 1998 - 00:00:00 CST