Re: Distinct query not working after database upgrade!!

The J Man wrote:

> Apologies...
> the query i am running is essentially this:
>
> SELECT DISTINCT A.AID, A.TEXT FROM A, B WHERE A.ID = B.ID AND B.date
>> =mydate;

Essentially is meaningless. If you can't provide DDM, DML, and an Oracle version you aren't going to get an answer.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org