<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">

  <title></title>

</head>

<body bgcolor="#ffffff" text="#000000">

Jeff Greenberg wrote:

<blockquote cite="mid:4B0AAEEA.8050306@ayendesigns.com" type="cite">

  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">

  <p style="margin-bottom: 0cm; margin-top: 0pt;">Brian Vuyk wrote:<br>

  </p>

  <blockquote cite="mid:4B0AAD12.7060502@brianvuyk.com" type="cite">

    <meta content="text/html;charset=ISO-8859-1"

 http-equiv="Content-Type">

1.) We are including extra data from the users table (wasn't central to

the question, so I omitted it to simplify)<br>

2.) How would you structure this exactly with subquery?<br>

  </blockquote>

Create a second table where the role id's have a weight for their

capability level<br>

</blockquote>

Ah, right, I get it now!<br>

</body>

</html>