RE: SQL Question

["Michael Smith" <msmith@xxxxxxxxxxxxxx>]

I am not sure how to use this statement.  Where would the user entered
part numbers go?

Michael 

 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Carel Teijgeler
Sent: Monday, June 28, 2010 2:27 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL Question

What about (untested):

WITH tmp AS(
                     SELECT MAX(PartNumber) FROM file 
                     GROUP BY JubNumber
                     )
SELECT MAX(JobNumber) FROM file
WHERE PartNumber IN(SELECT PartNumber FROM tmp)
GROUP BY PartNumber

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 28-6-2010 at 13:46 Michael Smith wrote:

> I have a data file:
>
> JobNumber   PartNumber
>
>      A1    123
>
>      A1    456
>
>      A1    111
>
>      B1    123
>
>      B1    789
>
>      C1    123
>
>      C1    456
>
>      C1    789
>
>
>
> The user will enter 3 part numbers; 123, 456, 789... and I need the
> results of my SQL select to return C1.  Is this possible? If so, can
> someone provide a "code snippet"
>
>
>
> TIA
>
>
>
> Michael Smith
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> Interne Virusdatabase is verouderd.
> Gecontroleerd door AVG - www.avg.com 
> Versie: 9.0.819 / Virusdatabase: 271.1.1/2820 - datum van uitgifte:
> 04/19/10 08:31:00