使用SQL CASE语句动态更改要从中选择的表

I'm trying to write a stored procedure and depending on a certain column value, I want to be able to change what table I select from. I'll try to give an example:I'm trying to write a stored procedure and depe