>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.

select T.MenuOption, case when UA.MenuID IS NULL then '' else 'Active' end as Flag
from CompleteList T LEFT JOIN UserActiveList UA ON T.MenuID = UA.MenuID