"Hotmail" <Hotmail@discussions.microsoft.com> wrote in message
news:1698075B-E076-4749-AD8A-B4F3F66AD2C2@microsoft.com...
>I am a bit of a newbie to SQL Queries and need some help with the following
> query.
>
> I have two tables in SQL 2000 which hold info about user and roles.
>
> In the first table I have a set of user info containing the user name and
> its email address. the user name is the primary key in this table.
>
> In the second table I have a set of role information which contains the
> role
> name, role email address and a reference to the user who holds that role.
> The
> user can be a member of many roles so he can be referenced in the roles
> table
> maultiple times.
>
> What I want is to output is an ammalgameted view of this data keyed on the
> user name as follows:-
>
> user1, user1 email address, role1 email address, role2 email address ...
> user2, user2 email address, role3 email address, role4 email address...
>
> I created a basic select qury between the two tables but it only produced
> the records on a separate row each. How can I get the multiple roles to
> link
> to the user in a single row?
>
> Thanks
> Hotmail
>