Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Steffen Kother Newsgroups: comp.databases.oracle.misc Subject: Re: Query help Date: Mon, 10 Mar 2014 09:12:55 +0100 Lines: 21 Message-ID: References: Reply-To: steffen.kother@gmx.net Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net zd1YvrYe+FbtzFK6dHL8FgLYCok+1fyKLUwknLLKg6ZjY5IEVZ Cancel-Lock: sha1:7uCoUEp8pqeeBhZeshXmQw718EU= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.28) Gecko/20120306 Thunderbird/3.1.20 In-Reply-To: Xref: csiph.com comp.databases.oracle.misc:814 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