
July 1st, 2003, 12:44 PM
|
|
Contributing User
|
|
Join Date: Sep 2002
Location: France
Posts: 55
Time spent in forums: < 1 sec
Reputation Power: 11
|
|
or shorter :
Code:
select *
FROM mediabarcodes
WHERE NOT (
(media_type in (4,5)
AND media_size in (15,10)
AND sheets_per_media_cassette in (100,20)
) OR (
media_type = 3
AND media_size in (15,1,2)
AND sheets_per_media_cassette in (80,20)
) OR (
media_type = 1
AND media_size in (1,2)
AND sheets_per_media_cassette = 80
)
);
|