I need the sql for the following which has to work on access 2003.
I have 2 tables
List1 and Lookup1
List1 contains user_name and role_description
Lookup1 contains role_id and role_descrition.
There can be multiple roles for a user
I need to produce a list in the format.
The List1 table contains
The lookup contains
The output needs to look like