Distinct values only 1

[Pekka]

Hi,
I have a following data forexample:

Tp Tp_k Se_1
A10 B10 1
A10 B10 2
A20 B11 2
A20 B10 1
A20 B12 1

I would like to have those Tp values that have nothing else than Tp_k = B10 rows. In my example I would only accept Tp=A10.

Pekka

"every dog will have his day

 

[JarlH]

SELECT DISTINCT Tp
FROM pekkatable
WHERE Tp NOT IN
(SELECT Tp FROM pekkatable
WHERE Tp_k <> 'B10')


Kippis!

 

[Pekka]

Thanks, jag tackar och pockar.
Skål!

Pekka

"every dog will have his day