View Single Post
 
Old September 20th, 2010, 03:38 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

I'm no Oracle expert but usually the IN operator is part of the WHERE clause:
Code:
SELECT * FROM CUST
WHERE Channel IN ('0007', '9999','0001')
ORDER BY Channel ASC;
__________________
Joe
http://joe.fawcett.name/