Use a dereference in a select statement

[Will_Henry]

Is it possible to do something like this?

SELECT(daily_schedule[Unique_User_Table_ID].[email], [Unique_User_Table_ID].[Emp_Role] = “Manager”)

The dereference in the second part of the select statement works (using Emp_Role) but trying to select email in the first part of the select statement returns a column not found error.