Hi,
This is possibly absolutely trivial but I am lost...
A table URIGHTS which stores an ID and the RIGHTs this ID has. One ID may
have many rights and accordingly records in table, sample:
ID RIGHT
---------------------
20 1
20 2
20 5
20 10
30 2
30 10
Now I need to find out which IDs have, say rights 2 AND 5 AND 10.
What would be the simplest query?
Thanks!