My colleague has written me a sql query.could you help me resolve

Question

write a query which returns a list of contacts and user roles they have:

columns are :

contact ID
forename
surname
user role name

user roles are in the .
link between contacts and user roles is in the role_membership table

could you help so i can understand

Answer 1

Just like this code select contact.contactid,role_membership.rolenname where contactid=roleid
Ps.please correct the name,that just example

Answer 2

GRUNDSÄTZLICH JA