SQL Server 2016 - 隐藏列不会从嵌套选择返回

I hope someone can help me here. I'm not a SQL developer so my knowledge is quite limited. I'm trying to return the ValidFrom column in a nested SQL query from scala, but it doesn't appear. I can return it from a non-nested query, but it needs to be nested. In its simplest format it looks like this: I hope someone can help me here. I'm not a SQL