Re: Sybrand Bakker: Any suggestions?

Martin,
Thanks for the suggestion ..........unfortunately that was something I'd all ready tried earlier in the game. Nevertheless, any other suggestions are certainly welcomed. I believe there must be a way, but I'm starting to feel a little hopeless.

"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message news:3AC2163D.59BBDA69_at_0800-einwahl.de...
> Did you try
>
> select distinct ...
>
> instead of
>
> select ...
>
> ?
>
> Martin
>
>
>
> Sk8er wrote:
> >
> > My immediate stumper lies within the problem that there are 2 tables but
> > only 1 PAYMENT_RECVD column (datatype NUMBER(9,2)) whereas there are 2
> > different collectors ( 2 seperate columns with datatype CHAR) AND 2
> > different dates (2 seperate columns with datatype DATE). Trying to
 figure
> > out the amount of payment received by each INDIVIDUAL collector seems to
 be
> > impossible to abstract. This is what I've unsuccessfully tried:
> >
> > SELECT b.collector2, b.coll2_date,
> > a.payment_recvd
> > FROM collectr.acct a, collectr.contact b
> > WHERE b.coll2_date
> > BETWEEN to_date('20-MAR-2001')
> > AND to_date('28-MAR-2001')
> > AND b.call_num=a.call_num
> > AND b.collector2<>a.collector1
> > AND b.coll2_date<>a.coll1_date
> > ORDER by 1;
> >
> > Also.............sometimes, but not always, COLLECTOR1 can be the same
> > person(sometimes in the same case size and sometimes in different case
 size)
> > as COLLECTOR2 and.......... COLL1_DATE can sometimes, but not always, be
 the
> > same as COLL2_DATE. I currently have only SELECT ON privileges to this
> > schema so my BIG questions are: Is there a query that can abstract this
> > information that I need? And if so, can I obtain the amounts of both
> > collectors within the same query? Any help is greatly appreciated.
>
>
Received on Wed Mar 28 2001 - 21:42:49 CST