How to do sql statement with except 1

[inarobis]

Hello all,


I would like to have all the elements belong to this record
= 'Geo' but not the element = 'USA;

Any idea?

Ina

This is my query
================
select distinct record.element as element
from record where record.Type = 'Geo'
except
(select record.element as element
from record
where record.element = 'USA');

 

[mutley1]

select distinct record.element as element
from record
where record.Type =  'Geo'
and record.element <> 'USA'

If I read your question right!

Rgds,

M.

 

[inarobis]

Thanks a lot! I was stuck in this except and I did not see like that. Simple

Ina