<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yep, that will do it too.<br>
<br>
Thanks for the suggestion!<br>
<br>
nan wich wrote:
<blockquote cite="mid:954154.95547.qm@web180316.mail.gq1.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">
<div>Brian Vuyk wrote:</div>
<div>> 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;</div>
<div> </div>
<div>You might find something like this easier to maintain (think
about an array, which could also map the levels):</div>
<div>SELECT DISTINCT u.uid, ur.rid FROM {users} u RIGHT JOIN
{users_roles} ur ON ur.uid = u.uid WHERE rid IN (6, 8, 5, 7, 4) GROUP
BY uid;<br>
</div>
<p><font color="#ff007f"
face="bookman old style, new york, times, serif" size="4"><em><strong>Nancy
E. Wichmann, PMP</strong></em></font></p>
<p><font face="arial, helvetica, sans-serif">Injustice anywhere is a
threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></p>
<div> </div>
<!-- cg1.c204.mail.gq1.yahoo.com compressed/chunked Mon Nov 23 06:51:20 PST 2009 --></div>
</blockquote>
<br>
</body>
</html>