I have a table that have a complete list of menu options. I have another table that has a list of active menu options that a user has turned on.

I need an sql that will combine these two to show the complete list and flag the records that the user has selected.