Is it possible to select only equal to

[ainese]

Is it possible to select only equal to something, if so what is the
code?


.....

basically I have a table with esn numbers, and services types. ESN can
have up to 3 service types. Basic will be associated with every ESN
number but the other services types may not. I am trying to count the
esn numbers where SERVICE is only equal to BASIC....

any ideas on how to write this?

I am having trouble with the below code in that it is returning
duplicates due to the inner join, how do I omit these?


SELECT DISTINCT (Count(F.ESN)) AS ["Basic Activations"]
FROM Data AS F INNER JOIN Data AS G ON (F.ESN= G.ESN AND F.SERVICE=
"Basic" AND G.SERVICE <>"Data Push" AND G.SUBSCR_TYPE = "Service
Activation")
WHERE G.ESN NOT IN
(SELECT ESN FROM Data WHERE SERVICE = 'Tracking' );