Groups > comp.databases.oracle.misc > #814

Re: Query help

From	Steffen Kother <steffen.kother@gmx.net>
Newsgroups	comp.databases.oracle.misc
Subject	Re: Query help
Date	2014-03-10 09:12 +0100
Message-ID	<bo5ag7Fd38dU1@mid.individual.net> (permalink)
References	<bntv5hFr10uU1@mid.individual.net> <b703501e-65d3-4de3-a97c-5b8964cd9c51@googlegroups.com>

Show all headers | View raw

Hello David,

Am 07.03.2014 16:04, schrieb ddf:
> On Friday, March 7, 2014 6:16:33 AM UTC-7, Steffen Kother wrote:
>> [...]
>
> First off I'd be using lpad() instead of a case statement to format the values:

Thanks for that hint.

> What I don't  understand is you have a GROUP BY query for Access yet this is not the case for the Oracle version.  Why?  We  need a bit more information on what the result is supposed to be.

I know, want to get some results before I group them. But I didn't get 
some if I try to match SDDAT.SDKEY with GSDAT.GSPROGRP using lpad(). If 
I hard match SDKEY to '00DR' then I get some (wrong) results. I will 
check formats and also ask a tech for the database srtructure given by 
their program.

Thanks for your help.
-- 
Kind regards, Steffen

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-07 14:16 +0100
  Re: Query help ddf <oratune@msn.com> - 2014-03-07 07:04 -0800
    Re: Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-10 09:12 +0100
      Re: Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-10 13:30 +0100

csiph-web