I am not able to use a select query after in statement . Could you please help me out on this

Select custid,Field name,RowValue
From TblEmails as a
Unpivot
(
Rowvlaue for fieldName in (select fieldName from #column_names)
) As unpiv
Order by field name