Re: How to cope with missing values - NULLS?

Anne & Lynn Wheeler <lynn_at_garlic.com> writes:
> Select E#
> FROM EMP
> WHERE JOB='Clerk'
> OR NOT JOB='Clerk';

and slightly related to employees that might have multiple job classifications ... aka "Clerk" and one or more other classifications.

one solution is to come up with all possible composite job classifications involving "Clerk" and a table "Clerk" giving all possible composites ... and then all entries in the Clerk composite table are used when selecting employees that might possibly have job classifications which include Clerk.

-- 
Anne & Lynn Wheeler | http://www.garlic.com/~lynn/ 
Internet trivia 20th anv http://www.garlic.com/~lynn/rfcietff.htm