Cheers to all,

I have a table with these data

service_id-----------entity_id
---5---------|--------1------
---6---------|--------1------
---5---------|--------2------
---6---------|--------3------

What I need to select:
-----------------------

All entity_id's with service_id's equal to 5 and 6.
(or all entities that have both service 5 and service 6)
In this case this is entity_id=1 (but not 2 and 3).

Is there a way to do this?
And how would I do it?

I've tried to search and read up on it, but frankly I have not found
anything.

I have a strong feeling that this cannot be done, unless you go into
code and have logic there.
I'd also gladly do it with temp table, but that too didnt inspire a
solution from me.

The only way I thought of would be with 'GROUP_CONCAT', but that is
cheesy and as I use mysql this is not supported (yet).

Please Help,
Thanks a lot
Damjan

PS if for some reason you need sql for table and data:
INTRO:
-------
I have table mapper:

CREATE TABLE mapper (
   service_id      integer NOT NULL,
   entity_id       integer NOT NULL
)
GO

with data:

INSERT INTO mapper (service_id, entity_id) VALUES (5, 1);
go
INSERT INTO mapper (service_id, entity_id) VALUES (6, 1);
go
INSERT INTO mapper (service_id, entity_id) VALUES (5, 2);
go
INSERT INTO mapper (service_id, entity_id) VALUES (6, 3);
go

to view data:

SELECT
   m.service_id,
   m.entity_id
FROM mapper AS m
ORDER BY m.entity_id