where analysis-cat not in('d','c','f');
When I use this, its removing the records with blank values also.
Is there any way to avoid it?
Are you sure it is blank values, not NULLs?
You could try the following:
WHERE (analysis-cat IS NULL OR analysis-cat NOT IN ('d','c','f'));
Hope that helps,
Retrieving data ...