MySQL Query for displaying all rows of one table with yes/no if matching other table?

[oncouride]

I apologize in advance for the non technincal description on this problem!
I have two tables: UsersOptions and OptionsList..
For simplicity sake, OptionsList is below:

• ID - NAME
• 1 - Red
• 2 - Blue
• 3 - Orange

UsersOptions has many rows eg;

• ID - CLIENT - OPTION
• 1 - John - Red
• 2 - John - Orange
• 3 - Mary - Red
• 4 - Jill - Blue
• 5 - Jill - Orange
• etc..

Is there a query I can run that will give me the following output? (yes/no is not essential)

John's output:

• OPTION - YES/NO
• Red - y
• Blue - n
• Orange - y

Mary's output:

• OPTION - YES/NO
• Red - y
• Blue - n
• Orange - n

This is driving me crazy!Thanks to anyone that can help!