RE: OT another SQL question

["Ben McCormack" <ben.mccormack@xxxxxxx>]

Sorry that I don't think will work

Right try this

Select DeviceID from Device
Where DeviceID =       (select CheckID from
CheckID_table
           
      where CheckID NOT IN
      (
           
           
           
      Select DeviceID
>from
OR, could you use a loop in PL/SQL?

-----Original Message-----
From: Ben McCormack [mailto:ben.mccormack@xxxxxxx] 
Sent: 04 October 2002 14:06
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] OT another SQL question


Just guessing a way to do this

Create a table with the range of numbers that you wish to check against
called CheckID

And then do something like

Select Devices
Where DeviceID NOT in (select CheckID from CheckID_Table)

I hope that you get the idea

Regards

Ben

-----Original Message-----
From: Dr John Tankard [mailto:john@xxxxxxx] 
Sent: 04 October 2002 13:52
To: ukha_d@xxxxxxx
Subject: [ukha_d] OT another SQL question


Sorry for the OT post

Is it possible in SQL to do this :-

I have a table:-

Devices
--------
DeviceID
..


And in the table there are some missing device numbers ie

1000
1001
1003
1004

In SQL is it possible to list missing numbers ie 1002 ?

John




http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/





http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor

ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.