Hi,

I have a db in which I have a users table containing a list of all
the users and a groups table containing a list of all the different
security groups they are in. There is a many:many relationship
between them so I have user_group as a link table between them.

What I want to do is a select in which I retrive those users who are
only a member of one, specified, group.

A simplified table structure is below

users
=====
UID int not null PRIMARY KEY
Fname varchar
Lname varchar

groups
======
GID int not null PRIMARY KEY
GroupName varchar

user_group
==========
GID
UID
(Primary key is a composite of the above)


with sample data

users

================================================== ===================

groups

================================================== ===================

user_group

===================

I need a query to return UID,Fname and Lname from those who are only
a members of group 2 (ie Brian Baker). Getting one to return Alf and
Brian is trivial but I can't see how to return just Brian.

Any pointers?

--
Graham Drabble
http://www.drabble.me.uk/

Graham Drabble:


Take the query you have, use GROUP BY uid
and a clause HAVING COUNT(gid)=1


--
Erick