Sql Server view with very limited access
As soon as someone has access to SELECT from a view, he can also copy the result set and join it with other views or tables, he has access to.

If you need to follow those requirements, you would need to create a custom application, that does not allow copying of data.