Re: distinct
When I add it to group by it goes back to my original problem. The query repeats on fields that I don't want it repeating on but that I do want to be able to manipulate. Below is a sample of the output of the query:
CaseNum LastName FirstName Company
06-0001 Smith John
06-0002 Doe Jane
06-0002 Doe Jane
06-0002 Doe Jane
06-0002 Doe Jane
06-0002 Doe Jane
06-0003 Joe Smith Pharmacy
06-0003 Smith Joe
06-0003 Garcia Frank
Below is what I want the query to look like:
CaseNum LastName FirstName Company
06-0001 Smith John
06-0002 Doe Jane
06-0003 Joe Smith Pharmacy
06-0003 Smith Joe
06-0003 Garcia Frank
As of now I can only do this by using a Last/First/Max functions on [tblPaymentslst.PaymentAmount].
Perhaps there is no way to do this?
Subject
Views
Written By
Posted
8514
October 12, 2004 09:56AM
3267
October 12, 2004 01:25PM
2652
November 09, 2005 07:58PM
2342
March 31, 2006 08:41AM
2363
March 31, 2006 02:45PM
2442
April 03, 2006 07:28AM
2270
April 03, 2006 07:51AM
2326
April 03, 2006 11:58AM
2159
April 05, 2006 04:21AM
Re: distinct
2201
April 05, 2006 11:57AM
2204
April 05, 2006 04:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.