Re:

[Alan Shore <AlanShore@xxxxxxxx>]

This original question is turning out to be a doozy.
Nice try Rob, but what happens if qtemp/foxwell contains
2, 3,5 and 999,999,999 what do you do?



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill



                                                                       
             rob@xxxxxxxxx                                             
             Sent by:                                                  
             midrange-l-bounce                                          To
             s@xxxxxxxxxxxx            Midrange Systems Technical      
                                       Discussion                      
                                       <midrange-l@xxxxxxxxxxxx>       
             04/16/2008 08:55                                           cc
             AM                                                        
                                                                   Subject
                                       Re:                             
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       




This works on V6R1

with list(counter) as
(values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10))
select counter from list
where counter not in(select thekey from qtemp/foxwell)

So if qtemp/foxwell contains 2, 3 and 5 you will get back:  1, 4, 6, 7, 8,
9, 10


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
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.