Re: Query help

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.

[Quoted] 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