Re: A Bit of Query Help....
Date: Fri, 1 Feb 2008 05:57:56 -0800 (PST)
Message-ID: <9167a270-1a2a-475a-9c07-d5d1a3bc058a@j20g2000hsi.googlegroups.com>
On Jan 31, 8:48 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> I need to write a query or sub-query, but only use a parameter once.
> Take a look at this:
>
> A Z198051 27-AUG-07 27-AUG-07
> B Z199111 31-AUG-07 31-AUG-07
> C Z215180 17-OCT-07 17-OCT-07
> D Z27867 21-FEB-06 22-FEB-06
> E Z239557 28-DEC-07 28-DEC-07
> F Z230612 01-DEC-07 03-DEC-07
> G Z108701 22-NOV-06 23-NOV-06
> H Z171480 04-JUN-07 04-JUN-07
> I Z143538 02-MAR-07 02-MAR-07
> J Z107108 16-NOV-06 17-NOV-06
> K Z114553 18-DEC-06 19-DEC-06
> L Z168095 24-MAY-07 24-MAY-07
> M Z82875 22-AUG-06 23-AUG-06
> N Z71657 14-JUL-06 14-JUL-06
> O Z55598 19-MAY-06 19-MAY-06
>
> Basically the code (1st column) will be passed in, and I want to
> retrieve the ID (second column) for that code with the MAX date (3rd
> column).
>
> Problem being that the way the engine for this application is
> written,
> you can only pass 1 parameter to it. So, I can only pass the code
> once, which means I can only use it in the query once......
>
> I try things like this, but no luck:
>
> SELECT id
> FROM table1
> WHERE date1 = (SELECT MAX(date1)
> FROM table1
> WHERE code = 'E' AND id LIKE 'Z%');
>
> Any ideas? I've been playing with sub-selects and MAX(date), but it
> seems that I still need to put CODE in there twice......
>
> Thanks a bunch.
Posting this twice under two different subject headings won't get you any faster response.
It's also annoying. So, stop it.
David Fitzjarrell Received on Fri Feb 01 2008 - 07:57:56 CST