Example:

```
Declare @Division int = 1

IF @Division = 1 
BEGIN 
    SELECT * FROM A 
END 
ELSE IF @Division = 2 
BEGIN 
    SELECT * FROM B 
END

```

The thing is, I don't want to use `if statements`, as there's hundreds of `Divisions` to consider.

This is part of a larger query where it's joined onto other tables.

How do I do this?