Oracle 9i Union Query Dropping Records

[dmac06]

I have a union query that is not showing a few of the records. When I run the second part of the sql by itself all the records show. There are no matching records in the first part.

This view has been in use for months and this is the first time it's happened.

Any ideas?

 

[SantaMufasa]

DMac,

Let's pretend that I am a patient and you are a doctor. Let's also pretend that I came to you and said, "I woke up this morning and felt sick. Usually I don't feel sick...This is the first time in months that I've felt sick."

As a physician, would you want more information from me?

To help you with your inquiry, I would be intereseted in knowing:

1) the contents of your query,
2) the layout of your query tables,
3) the changes to your environment since your last successful run,
4) a few sample rows of data from each query table.

Let us know,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]