<!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">

Mick Knutson schrieb:

<blockquote

 cite="mid4c30ee7d0701090918i52a1a9b4t6fa0c29b1570fecf@mail.gmail.com"

 type="cite">

  <meta http-equiv="Context-Type"

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

select u.user_name, g.group_name<br>

from cms_users u,<br>

          cms_groups g,<br>

           cms_groupusers gu<br>

where user_name = ?<br>

and u.user_id = gu.user_id<br>

and gu.group_id = g.group_id<br>

</blockquote>

thanks for sharing.<br>

<br>

c.<br>

</body>

</html>