Report question

Question: Dynamically Changing what table to select from with SQL CASE statement