I have a table of people and a table of roles. A person can have several roles. I have a query which joins the two. How do I only return one of the joins per person - I don't care which join it returns. I needs all columns from both tables.
This is in MSSQL