Re: Sybrand Bakker: Any suggestions?

Can you give us an example what you get when you try the distinct? What goes wrong there?

If it is the case problem you should retrieve upper (b.collector2) or lower (b.collector2) or initcap (b.collector2). If it does matter what case spelling you have then both lines have to appear.

Martin

Sk8er wrote:
>
> 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 Thu Mar 29 2001 - 00:14:15 CST