如何从包含子查询的SQL查询中选择所有内容

I want to perform a mySQL query that returns all the results in a table but has an additional column that has values "selected" if they correspond to a separate query. For exampleI want to perform a mySQL query that returns al