<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Nov 23, 2009, at 10:18 AM, Brian Vuyk wrote:</div><blockquote type="cite"><div><font class="Apple-style-span" color="#000000"><br></font>SELECT DISTINCT u.uid, ur.rid FROM {users} u RIGHT JOIN {users_roles} ur ON ur.uid = u.uid WHERE rid = 6 OR rid = 8 OR rid = 5 OR rid = 7 OR rid = 4 GROUP BY uid;<br><br>Brian<br></div></blockquote></div><br><div>1) Why are you doing a join when all the info you are selecting is in the users_roles table? If you don't need it for some other reason, problem solved.</div><div>2) I've found it's generally better to use subqueries (where X in (select Y from Z)) rather than join and group.</div><div><br></div><div>- Ken Winters</div></body></html>