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